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 ;
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 :
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.
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.
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
Tags:
sql