please tell me the query to get details of the employee
having the second largest salary
Answer Posted / ravikiran
select top 2(salary) from emp_sal where
salary in (select sal from emp_sal order by sal desc)
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
What is constraints and its types?
Differentiate between mongodb vs. Sql server?
where the connection string store in the database
What is a covering index?
What are the security related catalog views? : sql server security
Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?
What are distinctive joins find as a part of sql?
How to update values in a table with update statements in ms sql server?
Difference between 2NF &3NF ?
what is a deadlock? : Sql server database administration
What is b tree index?
how can u get last observation in an unknown dataset ?
What number sorts of privileges are accessible in sql?
Some queries related to SQL
What are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?