Database - Interview Questions and Answers for 'Deloitte' | Search Interview Question - javasearch.buggybread.com
Javasearch.buggybread.com

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.
Label / Company      Label / Company / Text

   



Deloitte


   




Database - Interview Questions and Answers for 'Deloitte' - 3 question(s) found - Order By Newest

 Q1. Given an Employee Table with Salary Column, Find 2nd and 5th highest salary in a particular department.SQL2018-07-04 16:23:54

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 :   

   Like         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 ?


 Q2. Sort an Employee Object based on Name or AgeDatabase2019-03-31 08:36:02

Ans. Use Comparable or Comparator interface

 Help us improve. Please let us know the company, where you were asked this question :   

   Like         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 ?


 Q3. What is the main difference between unique key and primary key ?Database2020-02-13 08:15:53

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 :   

   Like         Discuss         Correct / Improve     Unique Key  Primary Key     Asked in 1 Companies


Related Questions

 Difference between composite , primary and unique key ?



Help us and Others Improve. Please let us know the questions asked in any of your previous interview.

Any input from you will be highly appreciated and It will unlock the application for 10 more requests.

Company Name:
Questions Asked: