order by

Returning Sorted Record Sets Using the ORDER BY Clause

  • Article

Having your data returned to you in some meaningful sorted order is important sometimes. If you don’t tell SQL Server you want to order the results of a SELECT statement then there is no guarantee that your result set will come back in a particular order. To make sure a result set is ordered you need to use the ORDER BY clause. In this article I will be exploring how to return an order result set by using the ORDER BY clause.

2015-01-16

10,316 reads

Blogs

Daily Coping 6 May 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

All jobs that ran during a given time frame.

By

Short post today. Simple query that will tell you every job that ran between...

Instructions for Handling Errors of MySQL and PHPMyAdmin

By

One of my clients, Justin Williams, is a blogger. He owns a website named...

Read the latest Blogs

Forums

Checking Up on Vendors

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Checking Up on Vendors, which...

Getting Started with MLflow in Azure Databricks

By Additional Articles

Comments posted to this topic are about the item Getting Started with MLflow in...

Container Images

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Container Images

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers