Interested to Buy Any Domain ? << Click Here >> for more details...
write the query for find the top 2 highest salary in sql
server
- 36 Answers
- 73958 Views
- Cranes, Jayanti Software, Medi Assist, Rmax, TCS, I also Faced
- E-Mail Answers
Answer Posted / suhail qaiser
or if u want 2nd highest then write this query
select Top 1 salary from ( select top 2 salary from
emp_table order by salary desc)temptable order by salary
asc.
| Is This Answer Correct ? | 29 Yes | 24 No |
Post New Answer View All Answers
What does asynchronous call backs means?
Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture
How to retrieve error messages using mssql_get_last_message()?
What is the difference between row_number and dense_rank?
Why use triggers?
Why do we use trigger?
How to trouble shoot if unable to connect SQL Server
Suggest a method of joining two tables.
What are the built in functions in sql server?
How to get a list of all tables with "sys.tables" view in ms sql server?
What is BLOCK statements in SQL?
Can another user execute your local temporary stored procedures?
What is difference between materialized view and view?
optimization techinques
Can we add a cpu to sql server?
