List:MySQL on Win32« Previous MessageNext Message »
From:labsy Date:July 16 2004 2:57am
Subject:DISTINCT query
View as plain text  
Hello!

could you please help me construct proper mysql query. I spent 8 hours
with testing, but no proper results :((

I have a LOG with at least "ID" and "recipient" fields.
I want to extract last 15 different recipients.

I tried this:
SELECT ID DISTINCT recipients
FROM log_table
GROUP BY recipients
ORDER BY ID DESC 
LIMIT 15

But this returns some unknown 15 different recipients, but not 15
last. Could you help me, please?


  

-- 
Regards,
Andrej
--------------------------------
e-mail:         labsy@stripped
Tel.:        +386 (0)7 45 210 44
GSM :         +386 (0)41 233 335
--------------------------------



Thread
DISTINCT querylabsy16 Jul
  • Re: DISTINCT querySGreen16 Jul