Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to find second highest salary of an employee.
- 27 Answers
- 28136 Views
- I also Faced
- E-Mail Answers
Answer Posted / kitcat
SELECT salary
FROM (SELECT salary FROM emp
ORDER BY DESC salary)
WHERE RowNum=2
| Is This Answer Correct ? | 1 Yes | 11 No |
Post New Answer View All Answers
what is a database transaction? : Sql dba
table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
Sql technical questions
How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?
What is the most restrictive isolation level? : Transact sql
What is t sql used for?
What are types of indexes in sql?
Can we use having without group by in sql?
What is the process of copying data from table a to table b?
What is insert command in sql?
How many joins can you have in sql?
How can I change database name in sql?
Is delete faster than truncate?
How much does sqlite cost?
What is primary key and foreign key?
