Tag Info

New answers tagged

0

You can find common records from single table with the following code: select emp_id, emp_name, sal from tbl_emp where emp_name in (select emp_name from tbl_emp group by emp_name having COUNT(*) > 1)



Top 50 recent answers are included