write the query for find the top 2 highest salary in sql
server
Answer Posted / girish
select max(salary) from emp where sal<(select max(salary)
from emp
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain boyce and codd normal form(bcnf)?
How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.
how to trace the traffic hitting a sql server? : Sql server database administration
Is it possible to have clustered index on separate drive from original table location?
Explain filtered indexes?
plss anybody specify tha constrian management system in dbms
how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?
What is the difference RDBMS and Graph Database?
What is the difference between join and inner join?
How to configure odbc dsn with different port numbers?
What is a trigger? Why we need it?
What is the purpose of a table?
How will you go about resolving deadlocks?
What it means to be triggered?
What is a raid and what are different types of raid configurations?