"Group By" clause in OracleDB?

select dno,count(*) from emp group by dno having count(*)>1;






select * from emp;






UNION operator combines two or more SELECT statements.
used to query data from two or more tables, based on a relationship between certain columns in these tables.