Add "limit 1" at the end of your select statment. For example: select * from mytable ... limit 1;
Bernard On Thursday 12 February 2004 09:17, Joao wrote: > Hello ppl, > > Do I Have any statement to get only the first n records in Select > statement? > > A substitution of mssql "TOP n" statement > > Tanks a lot, > > Jo�o Rodrigues -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
