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.
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