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
Is sql better than excel?
column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.
Explain the methods used to protect source code of pl/sql.
What is a call statement? Explain with an example.
What is the difference between sum and count in sql?
What is normalization in sql?
Why do we create stored procedures & functions in pl/sql and how are they different?
explain mysql aggregate functions. : Sql dba
how to check myisam tables for errors? : Sql dba
What does data normalization mean?
how do you know if your mysql server is alive? : Sql dba
What is sql catalog?
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
How to assign sql query results to pl sql variables?
How to call a javascript function from pl sql?