Collections:
Sorting Query Output in Descending Order in SQL Server
How To Sort Query Output in Descending Order in SQL Server?
✍: FYIcenter.com
If you want to sort a column in descending order, you can specify the DESC keyword in the ORDER BY clause. The following SELECT statement first sorts the "tag" in descending order, then sorts the "counts" in ascending order:
SELECT tag, counts, url, created FROM fyi_links ORDER BY tag DESC, counts GO tab counts url created SQA 728 sqa.fyicenter.com 2007-05-19 SQA 828 www.winrunner.com 2003-01-01 DEV 120 dev.fyicenter.com 2006-04-30 DEV 439 www.php.net 2004-01-01 DBA 390 www.mysql.com 2006-01-01 DBA 960 www.oracle.com 2005-01-01 DBA 972 dba.fyicenter.com 2007-05-19
⇒ Counting Rows with the COUNT(*) Function in SQL Server
⇐ Sorting Query Output by Multiple Columns in SQL Server
⇑ Using SELECT Statements and GROUP BY Clauses in SQL Server
2016-10-26, 1963🔥, 0💬
Popular Posts:
How To End a Stored Procedure Properly in SQL Server Transact-SQL? Where the end of the "CREATE PROC...
What Is ISAM in MySQL? ISAM (Indexed Sequential Access Method) was developed by IBM to store and ret...
How To Connect the Oracle Server as SYSDBA in Oracle? This is Step 4. The best way to connect to the...
Is SQL Server Transact-SQL case sensitive? No. Transact-SQL is not case sensitive. Like the standard...
What Is an Oracle Tablespace in Oracle? An Oracle tablespace is a big unit of logical storage in an ...