Friday, 20 April 2018

Select Statement

Irawen April 20, 2018 SQL 1 comment

The SELECT statement is used to select data from database and retrieve the information.

1. Select all columns from the table

Syntax :- SELECT * FROM table_name;

   Ex :- SELECT * FROM my_tab;

2. Select Particular columns the table

Syntax :- SELECT column_name1, column_name2,..............FROM table_name;

   Ex :- SELECT name, mobile FROM my_tab;