SQL WHERE – Video Tutorial

Leave a comment (0) Go to comments

Prior to understand Where clause, lets do a quick recap of SQL and then we will focus of WHERE clause.

What is SQL Queries ?

With SQL, we can query inside a database and have a result set returned.

A query like this:

SELECT FirstName, LastName FROM Person.Contact

this query will return result set like this:


SQL WHERE   Video Tutorial WHERE SQL sql server where clause how to limit rows in resultset how to filter rows in SQL

Video Tutorial

 

What is Where Clause In SQL ?

How to filter rows in SQL Server ?

How to restrict rows in SQL Query ?

SQL WHERE Clause – The WHERE clause is used to specify a selection, this WHERE clause is used for criterion.

we can also say, WHERE clause is used in SQL Statements to limit the number of rows returned.

SELECT <<column list>> FROM table WHERE column operatorvalue

Example:

SELECT * FROM Persons WHERE City='Sandnes' 

SQL WHERE   Video Tutorial WHERE SQL sql server where clause how to limit rows in resultset how to filter rows in SQL

Operators, we always use operator with where clause to specify condition, these are the most commonly used operators.

SQL WHERE   Video Tutorial WHERE SQL sql server where clause how to limit rows in resultset how to filter rows in SQL

EOF - SQL WHERE – Video Tutorial, SQL Server 2012 , 2008 R2 , 2008 , 2005 , 2000

Leave a Reply

Your email address will not be published. Required fields are marked *


*


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Notify me of followup comments via e-mail. You can also subscribe without commenting.