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 rownum?
what are the differences between require and include, include_once and require_once? : Sql dba
Why we use pl sql?
What is index example?
What are the advantages of sql?
What is sqlcommand?
What is character functions?
what is the command line end user interface - mysql? : Sql dba
How to place comments in pl/sql?
How to select unique records from a table?
Mention what pl/sql package consists of?
Is a secondary key the same as a foreign key?
What is delimiter in pl sql?
Explain what is an index?
Is there a way to automate sql execution from the command-line, batch job or shell script?