how to find nth highest salary
Answer Posted / anuj somvanshi
select salary from emp where rownum=n order by salary desc;
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How to create a ddl trigger using "create trigger" statements?
What is difference between standardization and normalization?
What do you do in data exploration
What is merge?
What command is used to rename the database?
what is package and it uses and how can u call a package
What is key set driven?
Can another user execute your local temporary stored procedures?
What are the different types of replication you can set up in sql server?
What is the Difference Between Primary and Foreign Key?
How to call a function from a stored procedure in SQL Server ?
How do I create an extended event in sql server?
Can we use max in where clause?
what are the three command line utilities and what are their primary functions?
What is SQL Azure Firewall?