Select in SQL

Select:-this command is used to retrieve the data from the database.it is used to display the data from the database.By using this command we can select whole data or a particular column.

Ex;-

in this we select entire data of the table.
first we create the table then insert the data  and after that we retrieve the values. by using the select statement.
* is used to select the entire data of the table.
if we want to select particular column then we use

Ex:-in this query we select only id column of the table.

Ex;-we select the name column

 Ex;-if you want to select one or more column at a time then write in this way.