> For the complete documentation index, see [llms.txt](https://mass-street-data-school.gitbook.io/deng100-workbook-example/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mass-street-data-school.gitbook.io/deng100-workbook-example/unit-2-introduction-to-sql-fundamentals/sql-language-basics/sample-code/ordering-data.md).

# Ordering Data

```sql
USE AdventureWorksDW2019MSDS

--One Column
SELECT FirstName, LastName
FROM dw.DimEmployee
WHERE 1 = 1
AND IsMostRecentRecord = 1
ORDER BY LastName ASC

--More Than One Column
SELECT FirstName, LastName
FROM dw.DimEmployee
WHERE 1 = 1
AND IsMostRecentRecord = 1
ORDER BY FirstName, LastName ASC

--One Column Descending And Ascending
SELECT FirstName, LastName
FROM dw.DimEmployee
WHERE 1 = 1
AND IsMostRecentRecord = 1
ORDER BY LastName ASC

--One Column Descending
SELECT FirstName, LastName
FROM dw.DimEmployee
WHERE 1 = 1
AND IsMostRecentRecord = 1
ORDER BY LastName DESC

--Multi-Column With Mixed Ordering
SELECT FirstName, LastName
FROM dw.DimEmployee
WHERE 1 = 1
AND IsMostRecentRecord = 1
ORDER BY FirstName ASC, LastName DESC
```