In this section, you will learn use of the select statement.

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

Related Tags for The SELECT statement for SQL:
c,  table,  data,  select,  sed,  word,  column,  key,  name,  tab,  to,  e,  use,  from,  m,  me,  umn,  s,  col,  at,  k,  is,  s,  s,  rd,  ab,  abl,  lum,  om,  ol,  o

More Tutorials from this section

• SQL Example, Codes and Tutorials
• Aggregate Functions
• Backup File With Separator
• Backup Into txt File
• Backup selected records into txt file
• Call Procedure
• Close Cursors in SQL
• Create After Insert Trigger in SQL
• Create Before Insert Trigger in SQL
• Create Before Update Trigger in SQL
• Create Delete Trigger in SQL
• Create a Simple Procedure
• Create After Update Trigger in SQL
• Create a database
• Creating Cursors in SQL
• The Normal Forms
• Database Normalization
• Second Normal Form (2NF)
• Third Normal Form (1NF)
• Data Normalization