Difference between queries
Posted: Sun Nov 07, 2010 12:04 pm
Hi ,
I need to findout difference between 2 queris.
For example:
Query 1 : select * from emp where emp_id=19 returns 10 records
Query2 : select * from dept where dept_id=10 returns 15 records. Both the tables have same records. i need the differnce of 5 records?
I need to findout difference between 2 queris.
For example:
Query 1 : select * from emp where emp_id=19 returns 10 records
Query2 : select * from dept where dept_id=10 returns 15 records. Both the tables have same records. i need the differnce of 5 records?