SQL Plus Question:
Download Questions PDF

Explain How do we eliminate the duplicate rows?

Answer:

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)

Download SQL Plus Interview Questions And Answers PDF

Previous QuestionNext Question
Explain What is an Integrity Constraint?Explain What is meant by SORTING and GROUPING?