The ORDER BY command takes two parameters:<\/p>\n
ASC:<\/strong> ASC command is the abbreviation of the word ASCENDIG.<\/p>\n With this parameter, we can sort textual expressions alphabetically from smallest to largest.<\/p>\n DESC:<\/strong> DESC command is the abbreviation of the word DESCENDIG.<\/p>\n With this parameter, we can sort textual expressions alphabetically from largest to smallest.<\/p>\n You can use asc and desc parameters in the table as follows.<\/p>\n ORDER BY columnName asc<\/p>\n To sort in more than one column:<\/p>\n ORDER BY column1 asc or desc, column2 asc or desc<\/p>\n Let’s reinforce it with an example.<\/p>\n First, let’s create our table.<\/p>\n Let’s add our data to our ascdesc\u00f6rnek table.<\/p>\n Let’s see how our data is sorted by sorting the textt column in our table as desc.<\/p>\n As seen above, we sorted the text column as desc, and our other column is affected by this and performs the sorting process as desc.<\/p>\n Let’s list the numerical value in column 1 as asc.<\/p>\ncreate table ascdescexample(text text, column 1 integer)<\/pre>\n
insert into ascdesc\u00f6rnek values ('a',1);\r\ninsert into ascdesc\u00f6rnek values ('b',2);\r\ninsert into ascdesc\u00f6rnek values ('c',3);\r\ninsert into ascdesc\u00f6rnek values ('d',4);\r\ninsert into ascdesc\u00f6rnek values ('e',5);\r\ninsert into ascdesc\u00f6rnek values ('f',6);\r\ninsert into ascdesc\u00f6rnek values ('g',7);\r\ninsert into ascdesc\u00f6rnek values ('\u011f',8);\r\ninsert into ascdesc\u00f6rnek values ('i',9);\r\ninsert into ascdesc\u00f6rnek values ('\u0131',10);\r\n<\/pre>\n![](\"http:\/\/www.farukerdem.com\/wp-content\/uploads\/2020\/12\/orderby1.png\")
<\/p>\n![](\"http:\/\/www.farukerdem.com\/wp-content\/uploads\/2020\/12\/orderby2.png\")
<\/p>\n