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
- 73160 Views
- Cranes, Jayanti Software, Medi Assist, Rmax, TCS, I also Faced
- E-Mail Answers
Answer Posted / priyanka
select salary from emp where rowno=3 order by sal desc.
but this query works only when you have to create index.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration
Explain what stored procedure sp_replcounters is used for? : sql server replication
If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio
What is a fan-out query in SQL Azure?
What are a scheduled jobs?
When do you think a developer should use sql server-based cursors?
What is the new security features added in sql server 2016? : sql server security
What is dbcc updateusage?
What is row-level compre?
you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration
Difference between connected and disconnected database in .net with sql server?
Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.
Do you know what are acid properties of transaction?
What is the purpose of self join?
How to retrieve error messages using mssql_get_last_message()?
