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 |
|
Tshepang
Starting Member
4 Posts |
 Posted - 2009-07-13 : 10:54:55
|
| Hi,I'm trying to make a query that will select the top 100 students in terms of marks from an exam written. Tried subqueries to order the data but SQL server 2009 tells met that you cant have an ORDER BY clause in a sub query does anyone have an idea of how to do this? |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
Selecting top 100 records based on a criteria