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 build data dictionary view an new database?
What is a proxy object?
Write a trigger example in oracle?
How to create a new table in your schema?
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
How to get maxsal , minsal, ename department wise in single query
Can you drop an index associated with a unique or primary key constraint?
WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?
Difference between varchar and varchar2 data types?
What is the difference between $oracle_base and $oracle_home?
What is the difference between substr & instr functions?
List the various oracle database objects?
How to view existing locks on the database?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
How to create a new oracle data file?