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.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 My Question

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-06-03 : 08:18:17
shishi writes "Hi,

A table contains information
of students & their marks
such as stud_id , stud_name , marks

I want to retrive first 10 ten top ranked/scored
students name . Howz it done ?

Thanx in advance
shishi"

drymchaser
Aged Yak Warrior

552 Posts

Posted - 2004-06-03 : 08:36:55
Need more info, like DDL and DML and expected results. Other than that look up "TOP" in Books Online.
Go to Top of Page

AndrewMurphy
Master Smack Fu Yak Hacker

2916 Posts

Posted - 2004-06-03 : 11:18:44
Also have a look at the FAQ's (and/or search the site) for advice on our opinion on requests to solve homework.
Go to Top of Page
   

- Advertisement -