Monday, July 27, 2015

SQL Tutorial - Lesson 5 - Where

Where clause in SQL is use to filter records based on a condition.

For example you wanted to filter employee data based on the manager you would write the command  like this.

select * from emp where manager ="john";

In the above statement sql will search for the employee records who work under john and display the output.



No comments:

Post a Comment