Contact US


Get Your Project Done by our experts
info@fundaofwebit.com

SQL SELECT STATEMENT

SQL SELECT STATMENT :

SELECT is used to select a particular column or show all the data which is stored in the database.

SQL SELECT SYNTAX:

This is item table:

Itemcode

Itemname

Price

4001

Pen

50

4002

Pencil

20

4003

notebook

40


To select column data:

SYNTAX:
SELECT coloumn1,column2......FROM Table_Name;

 Here, Column1,column2.... are the particular attributes you want to select from  the table.

EXAMPLE:

SELECT itemname, itemcode FROM item;

In this it will only show you the result of itemname and itemcode. 

SQL SELECT SYNTAX :

To retrieve all the records.

If you want to look for all the columns details that are stored in a table 

SYNTAX:
SELECT * FROM Table_Name;

EXAMPLE:

SELECT * FROM item;

In this all the values or data stored in item table will be displayed.

This is the two possible ways to select a record from the database.