SELECT COMMAND

SELECT:
SQL SELECT statement is used to fetch the data from a database table which returns data in the form of result table. These result tables are called result-sets.

SYNTAX:

SELECT column1, column2....columnN
FROM   table_name;

EXAMPLE:

SELECT no,name,mark1,mark2,mark3,result,class FROM student;

Displays the values of columns no,name,mark1,mark2,mark3,result,class from the table student.
OR

SELECT * from student;

Displays all the values of the columns present in the table.

SELECT  no,name from student;

Displays only  the values of the columns no,name present in the table.