*cough*ORDER BY*cough*Originally Posted by Pannonian
That’s easy:Originally Posted by Yun all-Din
SELECT TOP 1 UserName, IgnoredNo FROM Users ORDER BY IgnoredNo DESC
----------
Sigurd Fafnesbane, 2777
*cough*ORDER BY*cough*Originally Posted by Pannonian
SELECT * FROM Users WHERE Users.TehBan > 1 SORT BY Users.TehBan
123456,"Devastatin Dave",153
123457,"Tribesman",97
...
That’s easy:Originally Posted by Yun all-Din
Id like to see who the most ignored members were
you know the guys that talk talking but no ones listening
SELECT TOP 1 UserName, IgnoredNo FROM Users ORDER BY IgnoredNo DESC
----------
Sigurd Fafnesbane, 2777
Last edited by Sigurd; 06-26-2007 at 15:43.
Status Emeritus
![]()
Bookmarks