SQL Where Clause

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 ServerSQL Update StatementSQL Select StatementSQL Insert StatementDrop Table SQL ServerRename Table in SQL ServerCreate Table SQL ServerSchema In SQL ServerSQL Server OperatorsData 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

sql where clause