SQL SELECT Statement

SELECT statement

Used to select data from the database

The SELECT statement is used to select data from the database.

The result is stored in a result table, called the result set.

SQL SELECT Syntax

SELECT Column_name,column_name
from table_name;

Demo Database

SELECT * from Zt_user zu WHERE zu.realname= ' Yechangchi '

SQL SELECT DISTINCT statement

In a table, a column may contain multiple duplicate values, and sometimes you might want to list only different (distinct) values.

The DISTINCT keyword is used to return only different values.

SQL SELECT DISTINCT Syntax

SELECT DISTINCT Column_name,column_name
from table_name;

SELECT DISTINCT Instances

SQL SELECT Statement