Subject | Top N Orders |
---|---|
Author | Mahesh Ishwar |
Post date | 2003-07-16T09:29:05Z |
Hi All,
Can I've a top N query where I can get the top N data for a particular group. For example :
I've a sales tables which contain data for each & every sale. I want ot have Top 2 sales of each month.
The 'Select First X.....' clause seems to be only for the result set & not the group.
Thanx.
Meghansh.
---------------------------------
Yahoo! Plus - For a better Internet experience
[Non-text portions of this message have been removed]
Can I've a top N query where I can get the top N data for a particular group. For example :
I've a sales tables which contain data for each & every sale. I want ot have Top 2 sales of each month.
The 'Select First X.....' clause seems to be only for the result set & not the group.
Thanx.
Meghansh.
---------------------------------
Yahoo! Plus - For a better Internet experience
[Non-text portions of this message have been removed]