Group/Sort rows with column same value together in groups and order each group by date DESC-CodePudding

Home > Back-end > Group/Sort rows with column same value together in groups and order each group by date DESC

Group/Sort rows with column same value together in groups and order each group by date DESC

Time：10-27

I have the following table and want to group/sort rows that have same Name coumn value together and then sort each group by Date coulumn.

So, expected result is like shown below.

CodePudding user response：

If i understand your question properly then try this select * from tbl group by Name order by Name,Date

CodePudding user response：

Can't see the images,but you should try with PIVOT