SQL: Query clauses in SELECT statement

 

SELECT statement is a combination of multiple query clauses. Below table summarizes different clauses of SELECT statement.

 

Clause	Description
SELECT	To select all the columns or specific columns
FROM	Specifies the table information to retrieve the data, or specifies how to join the tables.
WHERE	Specifies the condition to filter the data.
ORDER BY	Used to get the records in sorted way.
GROUP BY	Group rows together using column values.
HAVING	Used to filter out the data

Previous                                                    Next                                                    Home