In Structured Query Language, the SELECT statement is the most regularly used command. It's used to access data in one or more database tables and views. It also retrieves the data that meets the criteria we specify.

We may also obtain a specific record from a certain column of the table by using this command. A result-set table is a table that keeps the record returned by the SELECT query.

Syntax of SELECT Statement

In this SELECT syntax, Column_Name_1, Column_Name_2, ….., Column_Name_N are the name of those columns in the table whose data we want to read.

Use the following SQL SELECT syntax with the * asterisk sign to obtain all rows from all fields of the table:

Examples of SELECT Statement

Here are distinct SQL example that will assist you in executing the SELECT command for retrieving records:

Examples

We must first construct the new table and then fill it with dummy data.

Use the following query to create the Student_Records table in SQL:

The following query inserts the record of intelligent students into the Student_Records table:

The SQL query below displays all of the values for each column in the Student records table:

The output of the above query is:

The values of a specific column from the Student Record table are displayed in the following query:

The output of the above query is:

SELECT Statement with WHERE clause

The WHERE clause is used in combination with the SELECT statement to retrieve only those entries from the table that satisfy the query's condition. The WHERE clause is used in SQL not only with SELECT but also with other SQL statements such as UPDATE, ALTER, and DELETE statements.

Syntax of SELECT Statement with WHERE clause

In the syntax, we specify the condition in the WHERE clause using SQL logical or comparison operators.

Example of SELECT Statement with WHERE clause

We must first create the new table and then fill it with fake records.

Use the following query to create the Employee_Details table in SQL:

The following INSERT query fills up the Employee Details table with employee records:

The data from the Employee Details table is shown using the following SELECT query:

The following query shows the record of those employees from the above table whose Emp_Panelty is 500:

This SELECT query displays the following table in result:

SQL SELECT Statement with GROUP BY clause

The GROUP BY clause is used in combination with the SELECT statement to display the column's common data:

Syntax of SELECT Statement with GROUP BY clause

Example of SELECT Statement with GROUP BY clause

We are going to select from this table:

SQL SELECT Statement with HAVING clause

The HAVING clause in the SELECT statement creates a selection in those groups which are defined by the GROUP BY clause.

Syntax of SELECT Statement with HAVING clause

SELECT column_Name_1, column_Name_2, ....., column_Name_N aggregate_function_name(column_Name_2) FROM table_name GROUP BY column_Name1 HAVING ;

Example of SELECT Statement with HAVING clause

SELECT column_Name_1, column_Name_2, ....., column_Name_N aggregate_function_name(column_Name_2) FROM table_name GROUP BY column_Name1 HAVING ;

We are going to select data from this table:

The following query shows the total salary of those employees having more than 800 from the above Employee_Details table:

output

SELECT Statement with ORDER BY clause

When using the SQL SELECT statement, the ORDER BY clause sorts the records or rows. The ORDER BY clause sorts the results in ascending and decreasing order. By default, only a few database systems arrange column values in ascending order.

Syntax of SELECT Statement with ORDER BY clause

Example of SELECT Statement with ORDER BY clause in SQL

We are going to select data from this table:

Output:

This SQL query displays the following table in result: