SQL Query Interview Questions

ArtOfTesting

SQL Query Interview Questions

ArtOfTesting

SQL Query Interview Questions

Ques. Write an SQL query to find the maximum, minimum, and average salary of the employees.

SELECT Max(Salary), Min(Salary), AVG(Salary) FROM EmployeeSalary;

ArtOfTesting

Using aggregate function of SQL

Ans.

SQL Query Interview Questions

ArtOfTesting

SQL Query Interview Questions

Ques. Write an SQL query to fetch the EmpIds that are present in both the tables –   ‘EmployeeDetails’ and ‘EmployeeSalary.

SELECT EmpId FROM EmployeeDetails where EmpId IN (SELECT EmpId FROM EmployeeSalary);

ArtOfTesting

Using sub query-

Ans.

SQL Query Interview Questions

ArtOfTesting

SQL Query Interview Questions

Ques. Write an SQL query to find the current date-time.

SELECT NOW();

ArtOfTesting

MySQL-

SQL Server-

Oracle-

SELECT SYSDATE FROM DUAL;

SELECT getdate();

Ans.

SQL Query Interview Questions

ArtOfTesting

SQL Query Interview Questions

Ques. Write an SQL query to fetch top n records?

SELECT * FROM EmployeeSalary ORDER BY Salary DESC LIMIT N;

ArtOfTesting

In MySQL using LIMIT-

In SQL server using TOP command--

SELECT TOP N * FROM EmployeeSalary ORDER BY Salary DESC;

Ans.

SQL Query Interview Questions

ArtOfTesting

SQL Query Interview Questions

Ques. Write an SQL query to fetch all employee records from EmployeeDetails table who have a salary record in EmployeeSalary table.

SELECT * FROM EmployeeDetails E WHERE EXISTS (SELECT * FROM EmployeeSalary S WHERE E.EmpId = S.EmpId);

ArtOfTesting

Using ‘Exists’-

Ans.

SQL Query Interview Questions

ArtOfTesting

SQL Query Interview Questions

Ques. Write an SQL query to create a new table with data and structure copied from another table..

CREATE TABLE NewTable SELECT * FROM EmployeeSalary;

ArtOfTesting

Ans.

SQL Query Interview Questions

ArtOfTesting

SQL Query Interview Questions

Ques. Write an SQL query to remove duplicates from a table without using a temporary table.

DELETE E1 FROM EmployeeDetails E1 INNER JOIN EmployeeDetails E2 WHERE E1.EmpId > E2.EmpId AND E1.FullName = E2.FullName AND E1.ManagerId = E2.ManagerId AND E1.DateOfJoining = E2.DateOfJoining AND E1.City = E2.City;

For Complete List Check- ArtOfTesting

Ans.

Using delete with alias and inner join.