Jan 15, 2022 · Each sort expression may be optionally followed by a COLLATE keyword and the name of a collating function used for ordering text and/or keywords ASC or DESC to specify the sort order.

Jan 12, 2010 · How can I sort multiple columns in SQL and in different directions? For instance, 'column1' would be sorted descendingly and 'column2' ascendingly.

So I used the SQL Server Replicate function along with the length of the longest number to pad any shorter numbers with a leading space. Now 20 is sorted after 3, and so on. I was working with a view …

SELECT * FROM games ORDER BY name ASC But how can I sort the values of id column and save changes in table? Please, help.

Nov 3, 2025 · I need to sort a query's results by two methods at the same time. I want the first 3 records (returned) to be based on their prevalence in another table And then I want the rest of the results sorted

I have a SQL table with a datetime field that can be null. What is a simple way to sort query results ascending by datetime, but with rows where datetime is null at the end, not at the beginning?

Jan 3, 2012 · It is just a coincidence, the idea is to sort based on the ID only. This can be for several reasons. For example user-specified order, ordered by another resultset on another layer in the …

Oct 8, 2015 · SELECT NAME, SOME_OTHER_FIELDS FROM TABLE ORDER BY NAME I know I can code a sort function to do what I want, but because of how I am using the results, I can't seem to use …

Mar 10, 2010 · I have a SQLite database that I am trying to sort by Alphabetical order. The problem is, SQLite doesn't seem to consider A=a during sorting, thus I get results like this: A B C T a b c g I want ...

Case expression for Order By clause with Desc/Asc sort Asked 11 years, 4 months ago Modified 1 year, 1 month ago Viewed 46k times