Your query works, but I expect something more common.
I cannot use this query when I want to get not only one line in the result but first 10 lines.
Even though, thank you.
Dusan
On Fri, 30 Jan 2004 16:28:28 +0100, Rick F. van der Lans <[EMAIL PROTECTED]> wrote:
Hi Dusan,
Will this work for you:
SELECT * FROM table
WHERE <primary-key-column> = (select max(<primary-key-column>) from table)
If you use min, you will get the row with the lowest value.
best regards, Rick van der Lans
-- 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]
