Fixed Retrieving the last record in each group #dev #it #asnwer
Fixed Retrieving the last record in each group #dev #it #asnwer
Retrieving the last record in each group
There is a table messages that contains data as shown below:
Id Name Other_Columns - 1 A A_data_1 2 A A_data_2 3 A A_data_3 4 B B_data_1 5 B B_data_2 6 C C_data_1
If I run a query select * from messages group by name, I will get the result as:
1 A A_data_1 4 B B_data_1 6 C C_data_1
What query will return the following result?
3 A A_data_3 5 B B_data_2 6…
View On WordPress











