Answer Posted / srinath reddy
select * from emp e1 where 3 = (select count(*) from emp e2
where e1.salary <= e2.salary);
instead of answer we can say this as a solution where we can
find nth also
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
what is sub-query? : Transact sql
What is fmtonly in sql?
What is record data type?
What are the different schemas objects that can be created using pl/sql?
What is schema in sql?
what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba
Do we need commit after truncate?
What are types of joins?
What is cursor and its types?
What is sql indexing?
How do you bind variables in pl sql?
What is $$ in sql?
What is an oracle stored procedure?
What are expressions?
How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?