how to find nth highest salary
Answer Posted / nidhish
replace the N with wat ever number u want
select min(salary) from employee where salary in ( select
distinct top N salary from employee order by salary desc)
| Is This Answer Correct ? | 26 Yes | 17 No |
Post New Answer View All Answers
What is best institute to Learn DotNET And SQL in chennai?
How to copy data from one table to another table?
What are page splits?
How to check if a table is being used in sql server?
What is the difference between local and global temporary tables?
Explain can SSRS reports Cache results?
What are dml triggers and types of dml triggers?
What does truncate do?
How to create a dml trigger using create trigger statements?
What is dimension table? : sql server analysis services, ssas
Explain what is scheduled job and how to create it?
Is it safe to delete log files?
Can sub report data source be different from that of the parent report?
What is the importance of three tier architecture?
What is the difference between seek predicate and predicate?