write the query for find the top 2 highest salary in sql
server
Answer Posted / santosh kumar
select Top 1 salary from ( select top 2 salary from
emp_table order by salary desc)temptable order by salary
desc.
| Is This Answer Correct ? | 13 Yes | 14 No |
Post New Answer View All Answers
How do you delete duplicate records in sql server?
Where to find ntwdblib.dll version 2000.80.194.0?
Name the different type of indexes in sql?
What is database architecture? : SQL Server Architecture
How many null values we can have in a unique key field in sql server?
What is SQL Server?
What is the definition for sql server 2000?
can we have a nested transaction? : Sql server database administration
Do you know how to store and query spatial data?
What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?
List all the types of user-defined functions?
you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration
In which format does an image save in SQL Server database ?
What is use of attributehierarchyenabled? : sql server analysis services, ssas
Mention the differences between substr and charindex in sql server.