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
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
