/SQL/Sql query interview questions

Sql query interview questions

Sql interview questions

SELECT * FROM Table_name WHERE EmpName like 'A%'

1

Source: edureka.co

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;

1

Source: edureka.co

Sql query interview questions

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

0

Source: artoftesting.com

Sql interview query questions

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

0

Source: edureka.co

Similar codes

0 vote343 views1 answer
How to get number of months between 2 dates sql server
SQL
1 vote308 views1 answer
Sql server loop over query
SQL
0 vote275 views1 answer
Ora 00001 error catch plsql
SQL
0 vote272 views1 answer
Sql server obtener nombre sin espacios en blanco
SQL
3 votes286 views1 answer
Force using index oracle
SQL
0 vote289 views1 answer
Order by in codeigniter query builder
SQL
3 votes273 views1 answer
Oracle user quota unlimited
SQL
0 vote298 views1 answer
Code to move ietms from one table to another myswl
SQL
0 vote314 views1 answer
Mysql case when on date
SQL
0 vote275 views1 answer
Rabbitmq service not starting
SQL

Share