CODEWITHSUNDEEP
sqlsqlite
nuamehas
nuamehas

Reputation: 614

Select rows where column values are latest unique

Please, help to find appropriate query.

Task: table contains sms. Select latest sms from each conversation

Table example:

enter image description here

Query result

enter image description here

Thanks a lot in advance

Upvotes: 0

Views: 46

Answers (2)

Nishant Gupta
Nishant Gupta

Reputation: 3656

Here is the solution to your problem:

SELECT MAX(id) AS ID, conversationId, Max(date) AS Date 
FROM Table_name 
GROUP BY conversationId

Upvotes: 2

Yogesh Sharma
Yogesh Sharma

Reputation: 50163

Use subquery with correlation 

select * 
from table t
where date = (select max(date) from table where conversationid = t.conversationid)

Upvotes: 1

Related Questions