Select Statement in SQL
Select statement is most used command in SQL. It is used to fetch data from table and display data in tabular form.
The syntax of select statement is:
SELECT *FROM Table_Name;
Suppose we have a below EMP table
The syntax of select statement is:
SELECT *FROM Table_Name;
Suppose we have a below EMP table
Now we have above table which is already created and now we want to fetch all table data from above table so for this we use below Select statement to retrieve
SELECT Statement to retrieve Data from EMP table:
SELECT *FROM EMP;
Now after executing this command , the output will be :
Comments
Post a Comment