[HELP]SQL Script

[CAPITOL]

Looking for an SQL script wherein you can see the Top Level of character class. Anyone wanna share this?

 

[thevjfla]

SELECT TOP (???) FROM YourDB.dbo Character ORDER BY " ??? "

 

[CAPITOL]

For example I wanted to see the TOP 20 RF Character only in LEVEL

 

[thevjfla]

SELECT TOP 20 Name, CtlCode, Class, cLevel FROM [YourMuOnlineDB].[dbo].[Character] WHERECtlCode != 32 and CtlCode != 8 and Class = '96' or Class = '97' ORDER BY cLevel DESC