mysql query

rubyonrails-talk
1

Hi Everybody I have a table called mail which is as follows:

id user_id message_id conversation_id created_at == ===== ========= =========== ================= 22 2 12 10 2008-07-17 18:18:38 23 3 12 10 2008-07-17 18:18:39 24 1 12 10 2008-07-17 18:18:39 25 2 13 10 2008-07-17 18:29:16 26 1 13 10 2008-07-17 18:29:16 27 3 13 10 2008-07-17 18:29:17 28 1 14 11 2008-07-17 19:23:09 29 3 14 11 2008-07-17 19:23:10 30 2 14 11 2008-07-17 19:23:09

Now i want only those unique tuples whose conversation_id are same but out of it I want the latest i.e order by created_at desc. but I want all attributes. This is what I want for as an output

2

U can do like.

conversation_ids << [10,11] for conversation in conversation_id @my_mail << Mail.find(:last,:conditions => [‘conversation_id=?’,conversation])

end

i hope it will work :slight_smile:

3

thank for your reply. I resolved it in the similar fashion.