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: Dusan Kolesar (dusankolesarszm.sk)
Date: Fri Jan 30 2004 - 05:51:14 CST

Hello,

I want to get one record from :
SELECT * FROM table ORDER BY col.
When I add WHERE rowno<=1 :
SELECT * FROM table WHERE WHERE rowno<=1 ORDER BY col
the select result is restricted first and ordered at last.
I also tryed :
SELECT * FROM (SELECT * FROM table ORDER BY col) WHERE rowno<=1
but I obtained an error:
Missing delimiter: ) and there was "ORDER" highlighted.

Thanks for any idea,
Dusan

--
Dusan Kolesar
Helsinska 19
040 13 Kosice
Slovakia
e-mail : dusankolesarszm.sk
ICQ# : 160507424

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb