/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 vote214 views1 answer
Sql order by number not ordered
SQL
0 vote207 views1 answer
Mysql date without time
SQL
0 vote185 views1 answer
Sql select duplicates based on two columns
SQL
1 vote195 views2 answers
How to search date in sql query
SQL
0 vote184 views1 answer
Update table sql multiple set
SQL
1 vote181 views1 answer
Window function mysql
SQL
13 votes206 views2 answers
Sql online compiler
SQL
0 vote195 views1 answer
Postgres sequence name
SQL
1 vote310 views1 answer
Primary key reset in SQL database
SQL
35 votes200 views6 answers
Postgres
SQL

Share