Select clause in mysql.

the SELECT staement is the most important in the sql.

The main purpose of SELECT statement’s is to retrieve the data from the database table and return it in a tabular format. The SELECT is executed after the FROM clause. The SELECT Clause is used to get records in the form of a result set (i.e. rows) from one or more database tables.

SELECT * FROM Table_Name

SELECT Specific Columns

SELECT column1, column2, column3,......... FROM Table_Name
SELECT Id, Name, Department, Age, City FROM employee;

SELECT All Columns with Conditions

SELECT * FROM table_name [WHERE conditions];
SELECT * FROM ittutorial WHERE Department = ‘IT’;

Previous Next

Review & Rating

0.0 / 5

0 Review

5

(0)

4

(0)

3

(0)

2

(0)

1

(0)