Answer Posted / vasu
select * from emp a where &nth in(select count(b.sal) from
emp b where b.sal<=a.sal);
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
How to change user password in oracle?
How to drop a tablespace?
what is normalisation?what are its uses?
What is the difference between hot backup and cold backup in oracle?
What is an oracle user account?
How to use "out" parameter properly?
Explain the use of owner option in exp command.
How to resolve name conflicts between variables and columns?
How to create an oracle database manually?
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
What is meant by a deadlock situation?
What do you mean by merge in oracle and how can we merge two tables?
What are the ways tablespaces can be managed and how do they differ?
What is the disadvantage of User defind function?
What is the difference between primary key and unique key and foreign key in oracle?