Looking for an SQL script wherein you can see the Top Level of character class. Anyone wanna share this?
Printable View
Looking for an SQL script wherein you can see the Top Level of character class. Anyone wanna share this?
SELECT TOP (???) FROM YourDB.dbo Character ORDER BY " ??? "
For example I wanted to see the TOP 20 RF Character only in LEVEL
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