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. |
|
|||
| |||||||||||||||||||||||||||
| Database - Interview Questions and Answers for 'Deloitte' - 3 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 is a self Join and give an example of a self Join ? or What is self Join and What is it's purpose ? | |||||||||||||||||||||||||||
| Is there any schema in mongo DB ? | |||||||||||||||||||||||||||
| Difference between Inner and Outer Join ? | |||||||||||||||||||||||||||
| What is a Cursor ? | |||||||||||||||||||||||||||
| What are temp tables ? | |||||||||||||||||||||||||||
| 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 ? | |||||||||||||||||||||||||||
| Write an SQL to find all records having all numeric characters in a field ? | |||||||||||||||||||||||||||
| |||||||||||||||||||||||||||
| Ans. Use Comparable or Comparator interface | |||||||||||||||||||||||||||
| Help us improve. Please let us know the company, where you were asked this question : | |||||||||||||||||||||||||||
| Discuss Correct / Improve sql query Asked in 1 Companies | |||||||||||||||||||||||||||
| Related Questions | |||||||||||||||||||||||||||
| What is JDBC? Describe the steps needed to execute a SQL query using JDBC. | |||||||||||||||||||||||||||
| create an SQL query across multiple tables involving outer joins | |||||||||||||||||||||||||||
| Write SQL query to join 2 tables ? | |||||||||||||||||||||||||||
| |||||||||||||||||||||||||||
| Ans. Primary key will not accept NULL values whereas Unique key can accept one NULL value. A table can have only primary key whereas there can be multiple unique key on a table. A Clustered index automatically created when a primary key is defined whereas Unique key generates the non-clustered index. | |||||||||||||||||||||||||||
| Help us improve. Please let us know the company, where you were asked this question : | |||||||||||||||||||||||||||
| Discuss Correct / Improve Unique Key Primary Key Asked in 1 Companies | |||||||||||||||||||||||||||
| Related Questions | |||||||||||||||||||||||||||
| Difference between composite , primary and unique key ? | |||||||||||||||||||||||||||
