Simple select query

SQL SELECT Statement

The SELECT statement is used to select data (THROUGH WHICH WE CAN GET DETAIL) from a database.

The result is stored in a result table, called the result-set.

SQL SELECT Syntax

• SELECT column_name(s) FROM table_name

• SELECT * FROM table_name

• select * From table_name where condition

Example

• SELECT id,password FROM logintable

• SELECT id FROM logintable WHERE password="sam";