/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 vote341 views1 answer
Varchar format not case sensitive sql
SQL
0 vote357 views1 answer
How to know if table in rigt or left in sql
SQL
15 votes363 views7 answers
MYSQL
SQL
0 vote381 views1 answer
Oracle list datafiles
SQL
4 votes349 views2 answers
Mysql alter table set column unique
SQL
1 vote362 views1 answer
Sql order by where condition
SQL
0 vote327 views1 answer
First mysql
SQL
1 vote406 views2 answers
Drop table with constraints
SQL
2 votes396 views1 answer
Oracle find constraints referencing a table
SQL
0 vote332 views1 answer
Sqlite referential integrity
SQL

Share