QUERY ON STRUCTURED QUERY LANGUAGE

QUERY ON STRUCTURED QUERY LANGUAGE

Here’s an example of how to select files from the database using SQL statement: Study the syntax below:

SELECT [DISTINCT] column_name|*|expression AS column_alias FROM [table_or_view_name] SQL

Select statement permits you to choose values in the columns, literals, expressions, you may also choose single or multiple columns. Below is an example:

SELECT name FROM employees

When selecting these columns, make a list like column names or using the syntax below:

SELECT id, name, salary FROM employees
SELECT * FROM employees

With the keyword DISTINCT, SQL statement removes any duplicate values in the final result set. Below is an example of selecting distinct:

SELECT DISTINCT salary FROM employees

This will display values from the employee table so that you will know their salary levels. Max and min function can also be used to identity salary range.

SELECT MAX(salary) AS max_salary, MIN(salary) AS min_salary FROM employees