SQL Plus Interview Question:

Explain How do we eliminate the duplicate rows?

Submitted by: Administrator

Use the DISTINCT keyword right after SELECT...

i.e. SELECT DISTINCT customername FROM customer

select * from emp e where rownum=
(select max(rownum) from emp ee
where e.empno=ee.empno)
Submitted by: Administrator