Database - Interview Questions and Answers for 'Deloitte' | Search Java 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 ?
  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 ?
  Do you know of any DB statement that can be used if we would like to insert multiple rows into a table ?


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

 This question was recently asked at 'Deloitte'.This question is still unanswered. Can you please provide an answer.


 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

 This question was recently asked at 'Deloitte'.This question is still unanswered. Can you please provide an answer.


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

   Like         Discuss         Correct / Improve          Asked in 1 Companies


Related Questions

  Difference between == and .equals() ?
  Why is String immutable in Java ?
  Explain the scenerios to choose between String , StringBuilder and StringBuffer ?

or

What is the difference between String , StringBuilder and StringBuffer ?
  What are the difference between composition and inheritance in Java?
  Does garbage collection guarantee that a program will not run out of memory?
  What are different ways to create String Object? Explain.
  Why do we need Inner classes ? Cant we just work with outer classes wherever we implement Inner classes ?
  Why Char array is preferred over String for storing password?
  What do you mean by "Java is a statically typed language" ?
  What are points to consider in terms of access modifier when we are overriding any method?



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: