/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 vote207 views1 answer
Sql remove last 2 digit
SQL
13 votes193 views6 answers
Mysql update from select
SQL
4 votes222 views3 answers
Postgres drop all tables
SQL
0 vote193 views1 answer
Sql contains numeric characters
SQL
16 votes196 views1 answer
Mssql int max value
SQL
4 votes199 views3 answers
NOT NULL SQL
SQL
12 votes201 views1 answer
Docker run mysql image
SQL
0 vote193 views1 answer
Oracle query archivemode
SQL
2 votes255 views1 answer
Cannot return non-composite value from function that returns composite type
SQL
0 vote220 views3 answers
Characters found after end of sql statement
SQL

Share