Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / vamsi krishna
For 2nd maximum salary
select Max(sal) from EMP a where 2=(select COUNT(distinct(sal)) from EMP b where a.SAL<=b.SAL);
| Is This Answer Correct ? | 14 Yes | 3 No |
Post New Answer View All Answers
What are the differences between lost updates and uncommitted dependencies?
Explain a checkpoint?
Why do we need normalization?
How does Report Builder support Analysis Services cubes?
What is a coalesce function?
What are the restrictions that views have to follow?
What are the different type of replication in sql server?
Explain what is analysis service repository?
Explain system rowset functions?
Where is trigger in sql server?
How do you trace the traffic hitting a sql server?
Is truncate a dml command?
Do you know what are various aggregate functions that are available?
what are the types of indexes? : Sql server database administration
What guidelines should be followed to help minimize deadlocks?
