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
- 74151 Views
- Cranes, Jayanti Software, Medi Assist, Rmax, TCS, I also Faced
- E-Mail Answers
Answer Posted / tanay chaudhary
select * from(select emp.*,Dense_Rank() over(order by salary desc) as ranking from emp)as e where e.ranking in(1,2)
//emp=table name
//salary=column name
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.
What is advantage data architect?
What is used to replicate sessions between instances in coldfusion clusters?
What is the difference between seek predicate and predicate?
Explain about system stored procedure?
What is a matrix in ssrs?
What stored by the tempdb ? : sql server database administration
Is it possible to create trigger on views?
Can you explain important index characteristics?
How do I find the query plan in sql server?
Define a cross join?
What is Extended user-defined?
What is the downside of using udf?
How to create a testing table with test data in ms sql server?
Explain the difference between primary keys and foreign keys?
