mysql - Sort / Order Data with two or more filters -
how can sort or order info below using 2 fields: subject - year level - semester
eng1 - 1st year - 1st semester
eng2 - 1st year - 2nd semester
eng3 - 2nd year - 1st semester
eng4 - 2nd year - 2nd semester
math1 - 1st year - 1st semester
math2 - 1st year - 2nd semester
math3 - 2nd year - 1st semester
math4 - 2nd year - 2nd semester
in such way info (or subjects) ordered in manner below: 1st year 1st semester 1st year 2nd semester 2nd year 1st semester 2nd year 2nd semester
in short, i'm expecting output below: subject - year level - semestereng1 - 1st year - 1st semester
math1 - 1st year - 1st semester
eng2 - 1st year - 2nd semester
math2 - 1st year - 2nd semester
eng3 - 2nd year - 1st semester
math3 - 2nd year - 1st semester
eng4 - 2nd year - 2nd semester
math4 - 2nd year - 2nd semester
could help me ?
you can sort multiple field using order operator
example
select * result order year,sem mysql database sorting field sql-order-by
No comments:
Post a Comment