how to find nth highest salary
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
We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?
What is meant by indexing files?
How to enter comments in transact-sql statements?
What is report server project?
Can we perform backup restore operation on tempdb? : sql server database administration
What is partitioned view?
What keyword you will use to get schema appended to the result set of a ‘for xml’ query?
What do you understand by replication in sql server?
How to create a scrollable cursor with the scroll option?
What is conditional split?
Can foreign key be deleted?
What stored by the model? : sql server database administration
What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?
Can You Use A Stored Procedure To Provide Data To An Ssrs Report?
What are commit and rollback in sql?