-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Monday 07 June 2004 12:49 am, Emmanuel van der Meulen wrote: > I've looked in several books and searched Google but cannot get a way of > doing this. It seems Oracle has a 'FIRST' in their select which they use > for such a use case. But I do not see anything for MySql anywhere.
If your using a later mysql, you could use sub query with limit. Other then that, splitting the query is the only think off hand. - -- I am under the influence of sugar, caffeine, and lack of sleep, and should not be held responsible for my behavior. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.4 (GNU/Linux) iD8DBQFAxAMEld4MRA3gEwYRAgc5AJ0behkfDwijlpSANX1oXsRfNtwmKgCeOF4b j9366DtZYNuo2j0aTvQsudY= =ecrd -----END PGP SIGNATURE----- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]