how to find nth highest salary
- 103 Answers
- 163892 Views
- Cognizant, IBM, NexGen, Oracle, I also Faced
- E-Mail Answers
Answer Posted / udathayadav
select * from tablename.aliasname where nth=select
count(sal) from tablename where aliasname.sal<=sal
| Is This Answer Correct ? | 38 Yes | 26 No |
Post New Answer View All Answers
What are the differences between lost updates and uncommitted dependencies?
What is an indice?
write an SQL query to list the employees who joined in the month of January?
Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?
Explain acid?
What do you understand by user-defined function in the sql server?
What is sql or structured query language?
What the different types of Replication and why are they used?
Do you know clustered and non-clustered index?
What is indexing a document?
What’s the use of custom fields in report?
What is the difference between inner join and equi join?
What is always encrypted?
In which format does an image save in SQL Server database ?
What is the difference between ddl,dml and dcl commands?
