Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
remiwang
Starting Member
2 Posts |
 Posted - 2009-01-07 : 23:12:55
|
Hello everyone!!! I'm new member!!! I'm from Viet NamI have a question, Could you help me?How can we select 3 studiens have the max point from studiens list???Thanks!! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
ashishashish
Constraint Violating Yak Guru
408 Posts |
Posted - 2009-01-08 : 03:09:23
|
| Not the right place to ask your question post it in new to Sql or T-Sql 2000Thanks.... |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-01-08 : 03:11:01
|
SELECT TOP 3 StudentID, StudentPointsORDER BY StudentPoints DESC
E 12°55'05.63"N 56°04'39.26" |
|
|
|
ashishashish
Constraint Violating Yak Guru
408 Posts |
Posted - 2009-01-08 : 03:12:35
|
| Well its Looks like This,,,,,,SELECT TOP 1 * FROM(SELECT TOP (N-1) * FROM TableORDER BY yourOrderField DESC)tORDER BY yourOrderFieldor u just post ur table along wid some sample data.....and the expected results(OUTPUT).Thanks... |
|
|
|
remiwang
Starting Member
2 Posts |
Posted - 2009-01-08 : 11:28:41
|
| Thank you very much ^_^ |
|
|
|
|
|
|
New member!! Help me!! SOS