write the query for find the top 2 highest salary in sql
server
Answer Posted / krishna
select * from emp e where 2>=(select count(distinct esal)
from emp where e.esal<=esal)
| Is This Answer Correct ? | 8 Yes | 16 No |
Post New Answer View All Answers
List the ways in which dynamic sql can be executed?
Explain the use of keyword with encryption. Create a store procedure with encryption?
Where to find ntwdblib.dll version 2000.80.194.0?
What is Command line parameters in PLSQL.?
What is dbcc?
How to return the date part only from a sql server datetime datatype?
What is ssl in sql server?
What is best institute to Learn DotNET And SQL in chennai?
Differentiate sql server reporting services vs. Crystal reports?
Explain the types of indexes.
What is spid in sql server profiler?
can you implement data mining in SSRS?
What is a derived table?
Which operator do you use to return all of the rows from one query except rows are returned in a second query?
What is a domain constraint give an example?