news 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
You did not check the archives. Otherwise you would have found the answer SEVERAL times: WHERE ROWNO <= <integer> will do, BUT will work BEFORE ordering is done. Elke SAP Labs Berlin -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
