/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

3 votes226 views5 answers
Foreign keys
SQL
1 vote201 views1 answer
Where date = max(date) in sql
SQL
0 vote183 views1 answer
Insert thai language sql server
SQL
10 votes193 views1 answer
Oracle view dependencies
SQL
2 votes203 views1 answer
Oracle sql day of month from date
SQL
0 vote205 views2 answers
MySQL top percent
SQL
5 votes265 views1 answer
How to get all table names in sql query
SQL
1 vote197 views1 answer
Sql drop with dependencies
SQL
1 vote204 views1 answer
Mysql show table character set
SQL
1 vote199 views1 answer
Sql only five first row
SQL

Share