Database - Interview Questions and Answers for 'Deloitte' | Search Java Interview Question

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.

SQL

^{2018-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 Age

Database

^{2019-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 ?

Database

^{2020-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 is the difference between final, finally and finalize() ?

Search Interview Questions

Deloitte

Write a Review for Deloitte

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