a query to select maxmun 3 salaries of employee table
Answer Posted / raju
select * from emp a where 3>=(select count(distinct(b.sal))
from emp b where b.sal>=a.sal )
Is This Answer Correct ? | 4 Yes | 6 No |
Post New Answer View All Answers
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
Explain constraining triggers.
What are group functions in oracle?
How to display row numbers with the records?
what is a Nested Loop join?
In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??
How to retrieve data from an cursor to a record?
Explain what are the characteristics of data files?
What is index-organized table in Oracle?
What is the difference between substr and instr?
How can we find out the duplicate values in an oracle table?
What is the use of oracle?
What are the restrictions on external table columns?
What are the types of partitions in oracle?
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi