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 : [EMAIL PROTECTED]
ICQ# : 160507424
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
