Interested to Buy Any Domain ? << Click Here >> for more details...
write query for fourth maximum salary from employee table
- 14 Answers
- 24865 Views
- Mind Tree, SP Software, I also Faced
- E-Mail Answers
Answer Posted / dharmendra k. dixit
For Finding Nth Salary...
SELECT TOP 1 Salary FROM
(SELECT TOP nth Salary FROM Table Order by Salary Desc)Table
As Sal Order by Salary
| Is This Answer Correct ? | 5 Yes | 5 No |
Post New Answer View All Answers
What are indexes in sql?
What is the template in sql?
Why use triggers?
What is row-level compre?
what is package and it uses and how can u call a package
What happens if null values are involved in arithmetic operations?
Can primary key be a foreign key?
What is co-related sub query?
What gets stored inside msdb database?
What is database replication? What are the different types of replication you can set up in sql server?
What is the guest user account in sql server? What login is it mapped to it? : sql server security
hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail
What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?
What is coalesce and check constraint in sql server?
Tell me what is the significance of null value and why should we avoid permitting null values?
