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. |
|
|||
|
| ||||
| Interview Questions and Answers | ||||
| ||||
| Ans. SELECT MIN(FIELD) FROM (SELECT TOP 2 FIELD FROM TABLE ORDER BY FIELD DESC) or SELECT MAX(FIELD) FROM TABLE WHERE FIELD NOT IN (SELECT MAX(FIELD) FROM TABLE) | ||||
| Help us improve. Please let us know the company, where you were asked this question : | ||||
 Discuss Correct / Improve  sql | ||||
 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 ? | ||||
