FlipKart Offer

Translate to Tamil

Amazon Best Offer

AliExpress Offers

Online Income

Monday, 2 May 2011

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. 


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

 Share This Post


Smilely

Services

© 2014