write the query for find the top 2 highest salary in sql
server
- 36 Answers
- 69287 Views
- Cranes, Jayanti Software, Medi Assist, Rmax, TCS, I also Faced
- E-Mail Answers
Answer Posted / naren
select max(salary) as salary1 from employee where salary <
select max(salary) as salary2 from employee
| Is This Answer Correct ? | 27 Yes | 16 No |
Post New Answer View All Answers
Why the trigger fires multiple times in single login?
Does full backup break log chain?
What is the Disadvantage of indexed sequential file.
Where are sql server usernames and passwords stored in the sql server?
what is an index? : Sql server database administration
What is the difference between clustered index and primary key?
Do you know how to store and query spatial data?
Do you know how to implement service broker?
What is trace flag in sql server?
Do you have any idea about the tcl commands?
What are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?
Is resultset an interface?
What is stored procedures?
What is factless fact table? : sql server analysis services, ssas
Can we do dml on views?
