On May 19, 2006, at 10:28, Shariful Alam wrote:

> I need to retrieve Top n Product or Something like
> that. How can I get it through sql statement?
> Interbase has ROWS 1 TO n this facility. But firebird
> does not support ROWS. Is there any way to get this?

select [first m] [skip n]

HTH
________________________________________________________
Richard Wesley Software Engineer
Tableau Software
http://www.tableausoftware.com/ hawkfish
tableausoftware com