SELECT * FROM tab where c>0 ORDER by C UNION ALL SELECT * FROM tab where c=0;
Hagen
dan orlic wrote:
i have an question about ordering a set of records...
a b c d --------------------------------------------- 1 Tax 1 2000 1.33 1 Tax 1 1500 2.5 1 Tax 1 1000 3.25 1 Tax 1 0 4.5
But I want the records to return as such: ascending by (c) with the zero being the last record: like below:
1 Tax 1 1000 3.25 1 Tax 1 1500 2.5 1 Tax 1 2000 1.33 1 Tax 1 0 4.5
any suggestions?
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]