Answer Posted / karthik
select distinct sal from emp a where 2 = (select count
(distinct sal) from emp b where a.sal <= b.sal)
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Explain what are synonyms used for?
What is the usage of merge statement?
How to write text literals in oracle?
Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
Hi friends can u send the oracle 9i full version download link?????????????? please reply ?
What is a trigger and what are its types?
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
Can we commit inside a function in oracle?
How remove data files before opening a database?
can anyody please send me the dump for Oracle 10g certifications for DBA path?
How to create a table interactively?
What is ADDM Advisor in Oracle?
Why does Oracle not permit the use of PCTUSED with indexes?