/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 vote327 views1 answer
Sql check if column exists
SQL
20 votes300 views5 answers
Mysql reset auto increment to 1
SQL
0 vote305 views1 answer
An error occurred while installing mysql2 (0.5.3)
SQL
0 vote338 views1 answer
Exception message: The connection name 'SqlServices' was not found in the applications configuration or the connection string is empty.
SQL
0 vote344 views3 answers
Condition in count sql
SQL
6 votes308 views1 answer
Oracle desc table primary key
SQL
0 vote303 views1 answer
Mysql workbench download for iinux mint 19.3
SQL
6 votes316 views6 answers
Count mysql
SQL
0 vote325 views1 answer
Mysql subdate
SQL
1 vote330 views1 answer
How to convert number to hours and minutes in oracle sql
SQL

Share