Re: Problem on listing query results

[Nick Roper]

Hi Gleidson,

Here's a solution:

-----------------------------------------------------

DROP TABLE IF EXISTS temp;

CREATE TABLE temp
SELECT ID, USER, max(DATA) as user_data
from users
group by USER;

SELECT users.ID, users.USER, users.DATA
from users, temp
where users.USER = temp.USER
and users.DATA = temp.user_data
order by users.DATA desc;

-----------------------------------------------------


(Based on a technique described in MySQL Cookbook by Paul Dubois ISBN 0-596-00145-2)

--
Nick Roper