List:MaxDB« Previous MessageNext Message »
From:Rick F. van der Lans Date:February 2 2004 3:33pm
Subject:Order by and RowNo
View as plain text  
Hi Dusan,

If you want to get the first 5 (or whatever), this will work:

select * from table1 as t1 where 5 > (select count(*) from table1 as t2
where s2.primarykey < s1.primarykey)

Is this generic enough?

regards,
Rick van der Lans
Thread
• Order by and RowNoRick F. van der Lans2 Feb
  • Re: Order by and RowNoDusan Kolesar5 Feb