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
Thank you, this is very interesting and useful qeury.
Dusan
-- Dusan Kolesar Helsinska 19 040 13 Kosice Slovakia e-mail : [EMAIL PROTECTED] ICQ# : 160507424
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
