Hi people,
I’m working with MySQL and I want to select all rows of the table except the last one. In ANSI SQL dialect I would use the following query:
[tt]
SELECT *
FROM table
WHERE row_id != (SELECT MAX(row_id)
FROM table)[/tt]
But I have to rewrite it for MySQL. Can someone plz help me?
I’m working with MySQL and I want to select all rows of the table except the last one. In ANSI SQL dialect I would use the following query:
[tt]
SELECT *
FROM table
WHERE row_id != (SELECT MAX(row_id)
FROM table)[/tt]
But I have to rewrite it for MySQL. Can someone plz help me?