Answer Posted / nusrath sultana
select * from emp
where &n=(select count(distinct(sal)) from emp b
where emp.sal<b.sal)
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How to call a stored function in oracle?
What is merge statement used for?
Explain the importance of .pll extension in oracle?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
In oracle there is column command, how will you explain that?
How can windows applications connect to oracle servers?
How to write date and time literals in oracle?
What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.
Can we insert data in view oracle?
How to delete a user account in oracle?
What is save point in oracle database?
What is using clause and give example?
How to define an anonymous block?
What happens if the imported table already exists?
What is the difference between a primary key & a unique key?