|
|
SELECT |
The SQL SELECT statement is used to select data from a table and store it in a result-set. The SELECT statement begins with the SELECT keyword. A basic SELECT statement has three main clauses: * SELECT * FROM * WHERE The "SELECT" clause in the statement specifies the columns to be retrieved while the "FROM" clause specifies the table to be accessed, and finally the "WHERE" clause specifies the condition based on which records are chosen from the table. If the where clause is not present in a SELECT statement then all the records are chosen.The syntax of a SELECT statement is: SELECT <column name(s)> FROM <table name> WHERE <condition> |