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
define sql update statement ? : Sql dba
explain the options of myisamchk to improve the performance of a table. : Sql dba
What are triggers and its uses?
Why trigger is used in sql?
What does where 1 1 mean in sql?
How is data stored on a disk?
What is the use of nvl function?
Why should I use postgresql?
What are procedures used for?
What is the size of partition table?
Give the order of sql select?
What is a call statement? Explain with an example.
What is 19 null in sql?
what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba
What is difference between table and view?