how to find nth highest salary
- 103 Answers
- 163931 Views
- Cognizant, IBM, NexGen, Oracle, I also Faced
- E-Mail Answers
Answer Posted / raman sharma
For third highest salary u can use this syntax
select min(cin) from ( select distinct cin from
cws.usertable order by cin desc ) where rownum<4
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
What do you understand by replication in sql server? Mention the different types of replication in sql server.
Why I am getting this error when dropping a database in ms sql server?
What are the different sql server versions?
What is difference between global temporary tables and local temporary tables?
How do I delete a sql server database?
Write the SQL query to drop, truncate and delete table.
Define union, union all, minus, intersect?
Do you know what is user defined datatypes and when you should go for them?
What are the types of ssrs?
what is a traditional network library for sql servers? : Sql server database administration
What is the ‘fillfactor’?
What method is used by the Command classes to execute SQL statements that return single values?
What is read uncmmited?
How do I determine how many instances of sql server are installed on a computer?
What is the difference between a check constraint and a rule?
