SELECT Statement in SQL
The SQL Syntax
SQL is mostly
used by programmers who use SQL inside their language to build applications
that access data in a database.
Four
fundamental operations that apply to any database are:
Ø
Insert
new data -- INSERT
Ø
Update
existing data -- UPDATE
Ø
Remove
data --
DELETE
SELECT Statement in SQL
Select is the
most commonly used statement in select sql. The SELECT Statement in SQL is used to
retrieve or fetch data from a database.
sample Table:
The select sql general form
SELECT column1,column2 FROM table_name
column1 , column2: names of the fields of the table
table_name: from where we want to fetch
To fetch all the fields from the table Student:
SELECT * FROM TABLE
Comments