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'

idnameagecitybill
1Tom34Paris5300
2Jhony51London 400
3Ram64Delhi20000.7
4Simon23Portland32.65
 select  name  , age ,city  from customers;

Quantitative Aptitude
Reasoning
Programming
Interview