Find out the 3rd highest salary?
Answer Posted / vishal beri
Select ename from emp e where 2=(select count(distinct(Sal))
from emp where sal>e.sal)
Is This Answer Correct ? | 3 Yes | 5 No |
Post New Answer View All Answers
Is delete faster than truncate?
How many disk partitions should I have?
Why plvtab is considered as the easiest way to access the pl/sql table?
What is the meaning of disabling a trigger?
how many columns can be used for creating index? : Sql dba
Do prepared statements prevent sql injection?
What are all types of user defined functions?
How can you save or place your msg in a table?
What is sap sql?
What trigger means?
What is a column in a table?
What is sharding in sql?
What is the order of sql select?
What is where clause in sql?
What is sql select statement?