SELECT in SQL

SQL SELECT Query 

In Structured Query Language (SQL) , SELECT in sql is used to select the data from the database. 

SELECT Syantax
The basic syntax of the SELECT is given below 

SELECT  ColumnName FROM TableName ;

 Example :
example of select query is given below
                 
 SELECT  Address  FROM  Student ;
 

Student table :

Fig.Student table

1) SQL SELECT – For Selecting data of one column from table.

If you want to fetch the data of one column from table the use below select sql queries.

SELECT  Student Name  FROM student;

In above Sql Statement it will Select all the Record of student name column  from the student Table.

Sql query to select one column record from the table

2) SQL SELECT – for Selecting data of multiple  column from table
If you want to fetch the data of multiple column from the table then use the below select sql queries.

SELECT  Student name , age , class  FROM  student;

In above Sql Statement it will Select all the Record of student name, age, class column  from the student Table.

SQL query to select multiple column record from the table 

3) SQL SELECT (*)– For selecting data of all (*) column from table.
If you want to fetch the record of all column from the table then use the below select sql queries.

SELECT  * FROM student;

In above Sql Statement it will Select all the Record of all column  from the student Table

Sql Query to select all the record from the table

Hope !!! The above tutorial of select in sql helpful for you ...
Team
QA acharya

Tags: Sql select statement  , sql select query , sql select syntax , select statement ,sql  select , Syntax of select in sql

select in sql