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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-12-09 : 08:21:49
|
| Ryan writes "How would I select the TOP 5 rows for each Item No. from a table containing records that comprises 3 fields - namely Item No., Date & Qty.? The records will should be sorted by Item No. ASC and then Date DESC before the top 5 records are read into the recordset?" |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2003-12-09 : 09:18:59
|
| ClickyJay White{0} |
 |
|
|
|
|
|
SQL Select