[SQL] SELECT Statement | Example -trickcode

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:

                                          Ø  Read the data  --  SELECT

                                          Ø  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

Example :-

To fetch all the fields from the table Student:

SELECT * FROM TABLE