Search Interview Questions |  More than 3000 questions in repository. There are more than 900 unanswered questions. Click here and help us by providing the answer. Have a video suggestion. Click Correct / Improve and please let us know. |
|
|||
|
| ||||
| SQL - Interview Questions and Answers for 'Find 2nd highest salary sql database' - 1 question(s) found - Order By Newest | ||||
| ||||
| Ans. Select salary from (select salary from employee where department = order by salary desc limit 5) emp order by salary limit 1 AND Select salary from (select salary from employee where department = order by salary desc limit 2) emp2 order by salary limit 1 | ||||
| Help us improve. Please let us know the company, where you were asked this question : | ||||
 Discuss Correct / Improve  sql database find 2nd highest salary sql database  Asked in 1 Companies | ||||
 Related Questions | ||||
 What are Inner , Outer , Left and Right Joins in SQL ? | ||||
| What is JDBC? Describe the steps needed to execute a SQL query using JDBC. | ||||
| What are temp tables ? | ||||
| What is a self Join and give an example of a self Join ? or What is self Join and What is it's purpose ? | ||||
| Do you like Native SQL Apis like JDBC or JPA / Hibernate ? | ||||
| Is there any schema in mongo DB ? | ||||
| Difference between Inner and Outer Join ? | ||||
| What is a Cursor ? | ||||
| Does SQL allow null values ? Can we use it within Where clause ? | ||||
| Write an SQL to find all records having all upper case alphanumeric characters in a field ? | ||||
