OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
Order by and RowNo

From: Rick F. van der Lans (rickr20.nl)
Date: Mon Feb 02 2004 - 09:33:18 CST

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