Subject Top N Orders
Author Mahesh Ishwar
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]