Friday, October 3, 2014

10 Frequently asked SQL Queries In Interviews

          In this article I am giving example of some SQL query which is asked in most the of interviews who is having one or  two year experience on this field .whenever you go for java developer position or any other programmer position  interviewee expect that if you are working from one or two years on any project definitely you come across to handle this  database query, so they test your skill by asking this type of simple query.

 Que 1: SQL Query to find second highest salary of Employee

  Ans : There are many ways to find second highest salary of Employee in SQL, you can either use SQL Join or Subquery     to solve this problem. Here is SQL query using Subquery :

 select MAX(Salary) from Employee WHERE Salary NOT IN (select MAX(Salary) from Employee );

 Que 2: SQL Query to find Max Salary from each department.

 Ans :

 SELECT DeptID, MAX(Salary) FROM Employee  GROUP BY DeptID.

 Que 3: Write SQL Query to display current date.

  Ans: SQL has built in function called GetDate() which returns current timestamp.

 SELECT GetDate();

 Que 4: Write an SQL Query to check whether date passed to Query is date of given format or not.

  Ans: SQL has IsDate() function which is used to check passed value is date or not of specified format ,it returns 1(true)   or 0(false) accordingly.

 SELECT  ISDATE('1/08/13') AS "MM/DD/YY";

 It will return 0 because passed date is not in correct format.

 Que 5: Write a SQL Query to print the name of distinct employee whose DOB is between 01/02/2012 to 31/12/2013.

 SELECT DISTINCT EmpName FROM Employees WHERE DOB  BETWEEN ‘01/02/2012’ AND31/12/2013’;

 Que 6:Write an SQL Query find number of employees according to gender  whose DOB is between 01/01/1960 to  31/12/1975.

  Ans : SELECT COUNT(*), sex from Employees  WHERE  DOB BETWEEN ‘01/01/1960 ' AND  ‘31/12/1975’ GROUP BY sex;

 Que 7:Write an SQL Query to find employee whose Salary is equal or greater than 20000.

 Ans : SELECT EmpName FROM  Employees WHERE  Salary>=20000;

 Que 8:Write an SQL Query to find name of employee whose name Start with ‘S’

 Ans: SELECT * FROM Employees WHERE EmpName like 'S%';

 Que 9: find all Employee records containing the word "John", regardless of whether it was stored as JOHN, John, or  john.

 Ans : SELECT  * from Employees  WHERE  upper(EmpName) like upper('john%');

Que 10: Write a SQL Query to find year from date.

Ans :  SELECT YEAR(GETDATE()) as "Year";

No comments:

Post a Comment