Answer Posted / uday kiran
Its is like Nth highest salary.....
Select * from Employee where salary =
(Select max(Salary) from Employee where salary < (Select max
(Salary) from Employee where
Salary<(Select max(Salary) from Employee where
Salary <…………………………………………… N
| Is This Answer Correct ? | 15 Yes | 10 No |
Post New Answer View All Answers
What is primary key secondary key alternate key candidate key?
How do I run sql?
Does truncate table reset auto increment?
How many commands are in sql?
What is database migration?
Is sqlite thread safe?
What is sqlca in db2?
What is rownum in sql?
What is trigger in sql?
What is the starting oracle error number? What is meant by forward declaration in functions?
Which join is default?
what is the difference between a web-garden and a web-farm? : Sql dba
How do I find duplicates in a single column in sql?
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
What is the difference between sql, mysql and sql server?