SQL Select

The most commonly used SQL command is SELECT statement. The SQL SELECT statement is used to query or retrieve data from a table in the database. A query may retrieve information from specified columns or from all of the columns in the table. To create a simple SQL SELECT Statement, you must specify the column(s) name and the table name. The whole query is called SQL SELECT Statement. Syntax of SQL SELECT Statement: SELECT column_list FROM table-name [WHERE Clause] [GROUP BY clause] [HAVING clause] [ORDER BY clause]; table-name is the name of the table from which the information is retrieved. column_list includes one or more columns from which data is retrieved. The code within the brackets is optional. An SQL SELECT Example Table Name : custmast custcode custname city qty rate 1 Siva Srivilliputtur 50 70 2 Bala Sivakasi 30 56 3 Kanna Madurai 100 200 4 Vijay Chennai 30 30 5 Kodee Mumbai 60 30
We use the following SELECT statement:
Select custcode,custname from custmast Output: custcode custname 1 Siva 2 Bala 3 Kanna 4 Vijay 5 Kodee Select  * from custmast custcode custname city qty rate 1 Siva Srivilliputtur 50 70 2 Bala Sivakasi 30 56 3 Kanna Madurai 100 200 4 Vijay Chennai 30 30 5 Kodee Mumbai 60 30