should know this but need help. sql script max to min

10/21/2012 19:24 Svinseladden#1

i need a script that show ppl with much to min..

like show the ppl that have many accounts on 1 ip. or what account have the moust to lowest point count and so on..

i hade this but my braid is just no working now. i ust can't get that to work atm

brain.exe shutdown LOL

like rank but something i can change to points, users on a ip, gold bars and well so on

10/22/2012 00:34 -Lava.Corrupted.Saint-#2

Quote:

Originally Posted by Svinseladden

i need a script that show ppl with much to min..

like show the ppl that have many accounts on 1 ip. or what account have the moust to lowest point count and so on..

i hade this but my braid is just no working now. i ust can't get that to work atm

brain.exe shutdown LOL

like rank but something i can change to points, users on a ip, gold bars and well so on

This might help you i belive your looking for this.
[Only registered and activated users can see links. Click Here To Register...]

10/22/2012 02:23 ShaiyaHaven#3

I think what you're looking for is ORDER BY. Like, your second example for points would be:

Code:

SELECT * FROM PS_UserData.dbo.Users_Master WHERE Point > 0 ORDER BY Point DESC

Is that what you needed?

10/22/2012 12:23 Svinseladden#4

Quote:
Originally Posted by ShaiyaHaven
I think what you're looking for is ORDER BY. Like, your second example for points would be:
Code:
SELECT * FROM PS_UserData.dbo.Users_Master WHERE Point > 0 ORDER BY Point DESC
Is that what you needed?

yes yes thanks. just bad when brain.exe shut down :-(