Select rows where column values are latest unique

Question

Please, help to find appropriate query.

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

Table example:

Query result

Thanks a lot in advance

Adjust the sample data, have some date values in other order than id. — jarlh
– jarlh, Commented Mar 20, 2018 at 9:33

Nishant Gupta · Accepted Answer · 2018-03-20 09:27:05Z

2

Here is the solution to your problem:

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

answered Mar 20, 2018 at 9:21

3,6761 gold badge13 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Yogesh Sharma · Accepted Answer · 2018-03-20 09:21:22Z

Use subquery with correlation

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