Put Multiple Column Fields in Order by Syntax

Some times we need to arrange a table based on multiple column sequence.

In these condition we use this syntax.

select * from table_name order by column1,column2...columnn desc

Here your table consider first column as primary, when two or more data of first column equals, then it check for second column, and so on...

 

Ebook Download
View all
Learn
View all