SQL

sql query interview questions

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

sql queries questions

SELECT E.EmpFname, E.EmpLname, P.EmpPosition 
FROM EmployeeInfo E INNER JOIN EmployeePosition P ON
E.EmpID = P.EmpID AND P.EmpPosition IN ('Manager');

sql interview query questions

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

sql query interview questions

1
SELECT SUBSTRING(EmpLname, 1, 4) FROM EmployeeInfo;

basic sql queries interview questions

1
SELECT EmpID FROM (SELECT rowno, EmpID from EmployeeInfo) WHERE MOD(rowno,2)=0;

basic sql queries interview questions

1
SELECT EmpID FROM (SELECT rowno, EmpID from EmployeeInfo) WHERE MOD(rowno,2)=1;

sql interview questions

SELECT * FROM Table_name WHERE EmpName like 'A%'

sql queries questions

SELECT SUBSTRING(Address, 1, CHARINDEX('(',Address)) FROM EmployeeInfo;

sql query interview questions

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

sql queries questions

SELECT E.EmpFname, E.EmpLname, P.EmpPosition 
FROM EmployeeInfo E INNER JOIN EmployeePosition P ON
E.EmpID = P.EmpID AND P.EmpPosition IN ('Manager');

sql interview query questions

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

sql query interview questions

1
SELECT SUBSTRING(EmpLname, 1, 4) FROM EmployeeInfo;

basic sql queries interview questions

1
SELECT EmpID FROM (SELECT rowno, EmpID from EmployeeInfo) WHERE MOD(rowno,2)=0;

basic sql queries interview questions

1
SELECT EmpID FROM (SELECT rowno, EmpID from EmployeeInfo) WHERE MOD(rowno,2)=1;

sql interview questions

SELECT * FROM Table_name WHERE EmpName like 'A%'

sql queries questions

SELECT SUBSTRING(Address, 1, CHARINDEX('(',Address)) FROM EmployeeInfo;