SQL select

select command in sql is used to extract data from database.

---

SYNTAX :

select  column_name1,column_name2..... from table_name;

If you want to show all columns from database then write following syntax:

Syntax:

 select * from table_name;

---

Table Name 'customers'

id	name	age	city	bill
1	Tom	34	Paris	5300
2	Jhony	51	London	400
3	Ram	64	Delhi	20000.7
4	Simon	23	Portland	32.65

 select  name  , age ,city  from customers;