how to find nth highest salary
Answer Posted / smitam
select top 1 salary from emp where (salary<(select max
(salary) from emp ))ORDER BY salary DESC
Is This Answer Correct ? | 9 Yes | 21 No |
Post New Answer View All Answers
Explain system rowset functions?
Which database stores information about replication?
Explain try...catch with sql server?
Define ACID properties in a Database?
What is built-in/administrator?
Why use triggers?
What is user-defined inline table-valued function?
What is bcnf normalization form?
What is optimization and its types?
What do you mean by data integrity?
What is the difference between createstatement and preparedstatement?
What are different types of statement?
What is data modeling and Reterminal integrity?
How to include text values in sql statements?
Does a sql server 2005 select statement require a from?