⟩ Explain How do we eliminate the duplicate rows?
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)
Question and Answer:
Home SQL Plus
- Share
Popular Answers:
* There is no answer to the above question yet.
More Questions for you:
What is back order in OM?
What are the error tables in OM?
Tell me where we find the status of order information?
Explain what are the tables of auto invoice?
What is count(*) from po_vendors(any table)? What does it do andWhat is count(1) from po_vendors(any table)?What is count(0) from po_vendors(any table)the out put is same what is the difference?
What is the difference between request group and request security group in oracle apps?
Suppose for report i have to parameters those are from_date and to_date, so to_date should be greater when compare to from_date, if we are giving to_date is less then it must shows some error how we will make?
Tell me how to find the custom directory in front end?
i have 3 parameters like p1,p2,p3. In p1 i have 2 parameters like a,b.if pass parameter a p2 should be enable and p3 should be disable then if pass parameter b the vice versa?
How to Create a purchase order without a requisition?
