Jigal van Hemert wrote:
You can cheat a bit and use a UNION of one SELECT:
(SELECT field1,field2,field3 FROM table ORDER BY field3 ASC LIMIT 2) ORDER
BY field3 DESC;
This didn't work as expected. First, I need DESC sorting instead of
ASC to get what I need:
SELECT field1,field2,field3
From: Ashley M. Kirchner
Jigal van Hemert wrote:
You can cheat a bit and use a UNION of one SELECT:
(SELECT field1,field2,field3 FROM table ORDER BY field3 ASC LIMIT 2)
ORDER
BY field3 DESC;
This didn't work as expected.
Very odd!
These are my results on MySQL 4.0.21 using InnoDB
Jigal van Hemert wrote:
These are my results on MySQL 4.0.21 using InnoDB tables (it was suitable
data for this test, InnoDB was used for other reasons):
rpm -qa | grep -i mysql
MySQL-server-4.1.7-0
MySQL-devel-4.1.7-0
MySQL-client-4.1.7-0
MySQL-shared-compat-4.1.7-0