|
-
October 4th, 2001, 02:15 AM
#1
SQL code
WHat is the SQL code for selecting the top 3 records (out of 10 records) for every group? Let say I have 52 weeks, each week has 10 records (eg expenses),how can I select the top 3 records for
every week (week 1, week2....week52) using a single SQL statement?
It will be good if there are source code. Thanks!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote
