Simple SQL SELECT Statement

By: rekha singh | 29 Apr 2010 11:08 am

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="maya";

No Comments Posted for this Article.