SQL Plus Question:
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)
i.e. SELECT DISTINCT customername FROM customer
select * from emp e where rownum=
(select max(rownum) from emp ee
where e.empno=ee.empno)
| Previous Question | Next Question |
| Explain What is an Integrity Constraint? | Explain What is meant by SORTING and GROUPING? |