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
- 74207 Views
- Cranes, Jayanti Software, Medi Assist, Rmax, TCS, I also Faced
- E-Mail Answers
Answer Posted / ram murthy
SELECT TOP 1 salary FROM (SELECT DISTINCT TOP 2 salary FROM
employee ORDER BY salary DESC) a ORDER BY salary
| Is This Answer Correct ? | 3 Yes | 4 No |
Post New Answer View All Answers
What is a non equi join?
What’s the distinction between dropping a info and taking a info offline?
What are truncate options available in sql server? : sql server database administration
Indexes are updated automatically is the full-text index also updated automatically?
How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?
How to connect sql server management studio express to sql server 2005 express?
How to trouble shoot if unable to connect SQL Server
What are the advantages of the mirroring?
Do you know what is rank function?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
What is the difference between varchar and varchar(max) datatypes?
Explain active/passive and active/active cluster configurations?
Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
How do I view a trc file?
Tell me what do you understand by a view? What does the with check option clause for a view do?
