Hi All,

I wanted to have a top N query which should give me top N in a particular a group.
Something as under

Select Month, Top(sales)
From TableSales
Group By Month.

This query should give me Top sales in a particular and all the groups.
The 'Select First X ... ' applies first to result & not to the group. Is there any was to accomplish this in Firebird.

Perhaps I've to write a stored procedure for all groups.

Thanx.
Meghansh




---------------------------------
Yahoo! Plus - For a better Internet experience


[Non-text portions of this message have been removed]