SELECT Statement

The SELECT statement is used for accessing the contents of a table. Queries for using the SELECT statement is given bellow.

SELECT * FROM table_name;

The above SELECT query is used for displaying all the content of the table. '*'  indicates all content in that table.

Example:
SELECT * FROM Student;

For the customized content view of a table use the following SELECT query.

SELECT COLUMN_1, COLUMN_2........COLUMN_n  FROM TABLE_NAME;

Example:
SELECT name, address FROM Student;

SELECT with WHERE clause 
It is possible to access only a particular raw from a table using SELECT statement with the help of WHERE clause.
Syntax:
SELECT */COLUMN_NAMES FROM TABLE_NAME WHERE CONDITION;

Example:
From the Student table now i am going to access the details of 'prabeesh' only. I use the following query for it.
SELECT * FROM Student WHERE name='prabeesh';

It is also note that the table contents are also not case sensitive. Here the table contains two rows with name RESHMI and reshmi. Now i execute the following query.
SELECT * FROM Student WHERE Name = 'reshmi';