Select statement is used in SQL to select data from database objects. You will get a result table on the execution of select statement, which is called result-set.
Select column(s) From Table_Name
or
Select * From Table_Name
First will return only specified columns and second will return all columns in a table.
select and SELECT are same as SQL is not case sensitive.
Select Distinct:
--------------
Some columns may have duplicate data, select statement returns all occurrences of data whereas select distinct is used when you want to avoid duplicate records/data in result set.
This is applied on column for which you want to filter duplicate records.
Select Distinct column(s) From Table_Name
