SQL Tutorial
- SQL Introduction
- SQL Syntax
- SQL RDBMS Concepts
- SQL DataBases
- SQL Data types
- SQL Operators
- SQL Create DataBase
- SQL Create Table
- SQL Distinct
- SQL Rename Database
- SQL Rename Table
- SQL Drop Database
- SQL Select Query
- SQL Insert Query
- SQL Where Clasuse
- SQL Update Query
- SQL Delete Query
- SQL Like Query
- SQL Check
- SQL Default
- SQL Group By
- SQL Between
- SQL In
- SQL Views
- SQL Dates
- SQL Order By
- SQL Constraints
- SQL Not Null
- SQL And & Or
- SQL Unique Key
- SQL Primary Key
- SQL Foreign Key
- SQL Join
- SQL Inner Join
- SQL Left Join
- SQL Right Join
- SQL Full Join
- SQL Function
- SQL Avg()
- SQL Format()
- SQL Now()
- SQL Round()
- SQL Len()
- SQL Mid()
- SQL lowercase() & Uppercase()
- SQL Sum()
- SQL Min() & Max()
- SQL First() & Last()
- SQL Count()
SQL WHERE QUERY
The SQL WHERE clause is used to specify a condition while fetching the data from single table or joining with multiple tables.
If the given condition is satisfied then only it returns specific value from the table. You would use WHERE clause to filter the records and fetching only necessary records.
The WHERE clause is not only used in SELECT statement, but it is also used in UPDATE, DELETE statement, etc.
Syntax
SELECT column1, column2, columnN FROM table_name WHERE [Condition]
Example
| id | name | fee |
|---|---|---|
| 11 | Ashwani | 2000 |
| 12 | Sachin | 3000 |
| 13 | Deepak | 20000 |
| 14 | Soun | 200 |
| 15 | Sanjay | 3000 |
SELECT id,name FROM student WHERE fee=3000
Output
| id | name | fee |
|---|---|---|
| 12 | Sachin | 3000 |
| 15 | Sanjay | 3000 |