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