SQL Where Clause

Hi friends, in this post we will learn about SQL Where Clause or you can say Where Clause in SQL Server.

SQL Server WHERE clause is used to specify a condition while fetching data from table. On given condition satisfaction then only it returns data from the table. WHERE clause is also used in UPDATE, DELETE statement.

Earlier we had discussed about Delete Query SQL Server, SQL Update Statement, SQL Select Statement, SQL Insert Statement, Drop Table SQL Server, Rename Table in SQL Server, Create Table SQL Server, Schema In SQL Server, SQL Server Operators, Data Type in SQL Server and Drop-Delete SQL Server Database Using Management Studio or Query.

Where Clause in SQL Server Query:

In below query we are fetching data from STUDENT_INFORMATION table on specifying where clause in different columns.

----SELECT YOUR WORKING DATABSE-----
USE HIGHTECHNOLOGY
GO

----QUERY WITH WHERE CLAUSE EXAMPLES----
SELECT * FROM STUDENT_INFORMATION WHERE ID=1
GO
SELECT * FROM STUDENT_INFORMATION WHERE NAME='MANN'
GO
SELECT * FROM STUDENT_INFORMATION WHERE CLASS='X'
GO
SELECT * FROM STUDENT_INFORMATION WHERE PERMADDRESS='MUMBAI'
GO