SQL – SELECT Statement :
Sql Select Statement is used to fetch records from database table.
SQL – SELECT Syntax 1 (Select All Columns) :
SELECT *FROM TableName;
SQL – SELECT Syntax 2 (Select few Columns) :
SELECT ColumnName1, ColumnName2, ColumnName3,…. FROM TableName;
SQL Select All Columns Example :
Example
SELECT * FROM Users;
The above Query will display the results as :
SQL Select Few Columns Example :
Example
SELECT ID, Name, Email FROM Users;
The above Query will display the results as :
