SQL Select Statement/command:SQL Tutorial

SQL  SELECT  Statement:

The SELECT statement is used to select all data for a particular column. The data returned is stored in a result table, called the result-set

SELECT Syntax:

SELECT column1,column2,column3,....

FROM  table_name;

column1,column2.... are the field name of the table you want  to select data from the database

SELECT ALL COLUMN FROM TABLE :(you want to views all data from the table than * is used)

SELECT *

FORM table_name;

SELECT EXAMPLE:

SELECT  employee_name,age

FROM employee

Table name is employee and column name are employee_name, age