'select the count from two tables
select (select count(*) from emp) as count1,(select count (*) from empnew5) count2 from dual
++++++++++++++++++++++++++++++++++++++++++
'HOW TO ELIMINATE DUPLICATE ROWS WHILE DISPLAYING THE DATA
select distinct * from empnew where ename in
(SELECT ename FROM empnew GROUP BY ename HAVING ( COUNT(ename) > 1 or COUNT(ename)=1))
++++++++++++++++++++++++++++++++++++++++
'select the count from two tables
select (select count(*) from emp) as count1,(select count (*) from empnew5) count2 from dual
+++++++++++++++++++++++++++++++++++++++++++
select distinct empno,ename,sal,deptno,mgr from empnew where empno in
(SELECT empno FROM empnew GROUP BY empno HAVING ( COUNT(empno) > 1 ))
++++++++++++++++++++++++++++++++++++++++++++
SELECT ename,sal,count(*) NoOfOccurences FROM empnew GROUP BY ename HAVING ( COUNT(ename) > 1 )
SELECT ename FROM empnew GROUP BY ename HAVING ( COUNT(ename) > 1 )
+++++++++++++++++++++++++++++++++++++++++
select distinct * from empnew where ename in
(SELECT ename FROM empnew GROUP BY ename HAVING ( COUNT(ename) > 1 ))
+++++++++++++++++++++++++++++++++++++++++++
'HOW TO ELIMINATE DUPLICATE ROWS WHILE DISPLAYING THE DATA
select distinct * from empnew where ename in
(SELECT ename FROM empnew GROUP BY ename HAVING ( COUNT(ename) > 1 or COUNT(ename)=1))
select min(rowid)from empnew2 group by ename
delete from empnew2 where rowid not in(select min(rowid)from empnew2 group by ename)
CREATE TABLE EMPNEW3 AS selecT * FROM EMPNEW
+++++++++++++++++++++++++++++++++++++++
select distinct empno,ename,sal,deptno,mgr from empnew where empno in
(SELECT empno FROM empnew GROUP BY empno HAVING ( COUNT(empno) > 1 ))
SELECT empno FROM empnew GROUP BY empno HAVING ( COUNT(empno) = 1 )
+++++++++++++++++++++++++++++++++++++++
'intersect will display the common rows between the two tables
select * from empnew intersect select * from empnew5
+++++++++++++++++++++++++++++++
'select the count from two tables
select (select count(*) from emp) as count1,(select count (*) from empnew5) count2 from dual