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
- 73164 Views
- Cranes, Jayanti Software, Medi Assist, Rmax, TCS, I also Faced
- E-Mail Answers
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
What is trigger in salesforce?
Explain the collation?
What is statement level trigger?
What are partitioned views?
How does recursive cte works in sql server?
What is a transact-sql statement?
Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)
whats new about truncate in sql server 2008?
How to delete existing rows in a table?
What are “unrepeatable reads”?
optimization techinques
how we use window authentication connection with sql server.?
How to verify a login name with sqlcmd tool?
Can sql servers linked to other servers like oracle?
how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A
