Select Statement in SQL, SQL Tutorial

This page discusses - Select Statement in SQL, SQL Tutorial

Ads

The SELECT statement for SQL

     

SELECT key word is used to select data from a table. 

Syntax:

 

 

 

 

 

SELECT column_name(s)

FROM table_name

  Example: To select the content of columns named "LName" and "FName", from the database table called "email", use a SELECT .

SELECT   Name, Father_Name FROM EMAIL

The database table "email":

Name

Father_Name 

Address

Ram

Sonu

 delhi-5

  Select All Columns: To select all columns from the "email" table, use a * symbol instead of column names.

SELECT * FROM email

Advertisements

Ads
Share on Google+Share on Google+

Select Statement in SQL, SQL Tutorial

Posted on: April 18, 2011 If you enjoyed this post then why not add us on Google+? Add us to your Circles

Advertisements

 

Discuss: Select Statement in SQL, SQL Tutorial  

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Comments:0

Ads

 

Ads