how to order by date and by group mysql database?

Question

I would like to know how to regroup the results from mysql queries according to date by grouping.

Table Name = Visit_History

PIC FOR REFERENCE

Good grief. Surely there are some questions that should never be asked. — Strawberry, Jun 06 '16 at 07:26

score 0 · Answer 1 · answered Jun 06 '16 at 03:50

0

order first by group, and then by date

SELECT * FROM Visit_History ORDER BY Ref_Num, Ref_Date

answered Jun 06 '16 at 03:50

Jeff Puckett

score 0 · Answer 2 · answered Jun 06 '16 at 03:55

0

You can use ORDER BY for this ,

SELECT * FROM Visit_History ORDER BY Ref_Num, Ref_Date

answered Jun 06 '16 at 03:55

Vishnu R Nair

2 Answers2