Education and Career Forum

what is select statement of sql language...pleaes tell me wha is it

dear,

sql i.e. standard query language

by this software we use to save details in tabular form and can easily be retrieve and is highly confidential means no outsider will reach your important details untill he/she able to crack your password

select statement of sql language are as follows:

SQL SELECT statement

THIS STATEMENT IS MAINLY USED FOR selecting all data or some part of data from a database or from any table you have created under any class in this confidential software:

and the result is stored in the result table

SQL select syntax:


1)select column-name
from table-name


and


2)select * from table-name


note sql is not case sensitive means it treat SELECT as select


eg) let we have any table whose name is person and have columns as

lastname,firstname,personal-id,address,city etc


1)so, in order to select firstname and lastname from table person
we use following select statement:


ans )SELECT firstname,lastname from person


2) if you want to select all columns of table person then we use following statement:

ans)SELECT * from person


good luck