write the query for find the top 2 highest salary in sql
server
Answer Posted / k.elumalai
select max(salary)from emp where salary <(select sum(salary)
from emp)
| Is This Answer Correct ? | 6 Yes | 12 No |
Post New Answer View All Answers
Differentiate between sql temp table vs table variable?
How to disable a login name in ms sql server?
Can you tell me about the concept of ER diagrams?
How secure is sql server database?
What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
What do you understand by triggers and mention the different types of it?
What is co-related sub query?
What do you mean by data integrity?
Explain nested stored procedure. Syntax and an example for create nested stored procedure?
What are the types of processing and explain each? : sql server analysis services, ssas
Explain different backup plans?
what is the difference between Tabular and Matrix report?
Explain the Ways to improve the performance of a sql azure database?
Which language rdl files made of?
Describe how to use linked server?