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}

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 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 Char array is preferred over String for storing password?

Why do we need Inner classes ? Cant we just work with outer classes wherever we implement Inner classes ?

What is the difference between declaration, instantiation and initialization ?

Explain OOPs

or

Explain OOPs Principles

or

Explain OOPs Concepts

or

Explain OOPs features

or

Tell me something about OOPs

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.