SQL need halp.....

ASP Free Forums Sponsor:

May 27th, 2004, 11:34 PM

Contributing User

Join Date: Mar 2004

Location: Liverpool

Posts: 38

Time spent in forums: < 1 sec
Reputation Power: 5

SQL need halp.....

if i do not want to use MAX(score) what else can i use to look for max score?

SELECT Name, MAX(Score) FROM MyClass

May 28th, 2004, 01:21 PM

Doug G

Grumpier Old Moderator

Join Date: Sep 2003

Posts: 10,143

Time spent in forums: 3 Weeks 4 Days 22 h 33 m
Reputation Power: 181

select TOP 1 [Name], Score from MyClass order by Score DESC

__________________
======
Doug G
======
I didn't attend the funeral, but I sent a nice letter saying I approved of it. --Mark Twain

May 28th, 2004, 01:26 PM

Memnoch

Unholy Moderator

Join Date: Oct 2003

Location: In hell, where did you think?

Posts: 11,770

Time spent in forums: 3 Weeks 5 Days 7 h 9 m 35 sec
Reputation Power: 469

Quote:

Originally Posted by fc_ranger3

if i do not want to use MAX(score) what else can i use to look for max score?

The only way to get the MAX score, would be to use the MAX function.

Viewing: ASP Free Forums > Database > Microsoft SQL Server > SQL need halp.....

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

Forum Jump