T-SQL Tutorial

Using Where with Order by


SQL is a powerful programming language that allows you to manage and manipulate data in a relational database. One of the most common tasks in SQL is to sort and filter data based on specific conditions. This is where the WHERE clause and ORDER BY clause come in handy.


WHERE

The WHERE clause is used to filter rows from a table based on specific conditions. For example, you might want to retrieve all the rows from a table where the value in a specific column is greater than a certain value. Here is an example of a SQL query that uses the WHERE clause:

SELECT * FROM table_name WHERE column_name > 10;

In this query, the WHERE clause filters all the rows from the table where the value in the column named "column_name" is greater than 10.


ORDER BY

The ORDER BY clause, on the other hand, is used to sort the results of a query based on one or more columns. For example, you might want to retrieve all the rows from a table and sort them based on the value in a specific column in ascending or descending order. Here is an example of a SQL query that uses the ORDER BY clause:

SELECT * FROM table_name ORDER BY column_name ASC;

In this query, the ORDER BY clause sorts all the rows from the table based on the value in the column named "column_name" in ascending order.


Query with WHERE clause and ORDER BY

You can also combine the WHERE clause and ORDER BY clause in a single SQL query to filter and sort data based on specific conditions. Here is an example of a SQL query that uses both clauses:

SELECT * FROM table_name WHERE column_name > 10 ORDER BY column_name ASC;

In this query, the WHERE clause filters all the rows from the table where the value in the column named "column_name" is greater than 10, and the ORDER BY clause sorts the results based on the same column in ascending order.

Using the WHERE clause and ORDER BY clause together is a powerful way to retrieve and manipulate data from a relational database. By filtering and sorting data based on specific conditions, you can get the results you need quickly and efficiently.