SELECT In SQL- SELECT Statement In SQL

.
SQL SELECT Query - SELECT Statement in SQL

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

Syntax of SELECT
The basic syntax of the SELECT is given below 

SELECT  ColumnName FROM TableName ;


Example Of Select Statement
An example of a select query is given below
                 
SELECT  Address  FROM  Student ;

 
Student table :

Fig.Student table


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

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

SELECT  Student Name  FROM student;


In the above SQL Statement, it will Select all the Records of the student name column from the student Table.

SQL query to select one column record from the table



2) SQL SELECT 
-for Selecting data from multiple columns from table

If you want to fetch the data of multiple columns from the table then use the below select SQL queries.

SELECT  Student name , age , class  FROM  student;

In the above SQL Statement, it will Select all the Records of student names, ages, and class columns from the student Table.

SQL query to select multiple column records from the table 


3) SQL SELECT (*)-
For selecting data of all (*) columns from the table.

If you want to fetch the record of all columns from the table then use the below select SQL queries.

SELECT  * FROM student;

In the above SQL Statement, it will Select all the Records of all columns from the student Table

SQL Query to select all the records from the table



Hope !!! The above tutorial of select in SQL is 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 - Select Statement in SQL


Post a Comment

0 Comments