Sql query interview questions Code Example - Coding

sql query interview questions

SELECT EmpId
FROM EmployeeSalary
WHERE Project <>'P1';

sql interview query questions

1
SELECT TOP N * FROM EmployeePosition ORDER BY Salary DESC;

sql interview questions

SELECT TOP 1 salary
FROM(
SELECT TOP 3 salary
FROM employee_table
ORDER BY salary DESC) AS emp
ORDER BY salary ASC;

Related
select current_timestamp - interval '3 days'; Code Example
mysql dump with table query Code Example
mysql count rows returned Code Example
sql find second highest salary employee Code Example
sql select from multiple tables without join Code Example