menu

SQL – SELECT

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 all-c…sql-query

Select-all-c…ql-query

SQL Select Few Columns Example :

Example

SELECT ID, Name, Email FROM Users;

The above Query will display the results as :

Sql-INsert-in-Selected-columns

Advertisements