/SQL/Sql interview questions

Sql interview questions

Sql query interview questions

SELECT EmpId
FROM EmployeeSalary
WHERE Project <>'P1';

1

Source: artoftesting.com

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 interview query questions

1
SELECT TOP N * FROM EmployeePosition ORDER BY Salary DESC;

0

Source: edureka.co

Similar codes

0 vote235 views1 answer
If exist column in table drop sql query mysql
SQL
2 votes212 views1 answer
Oracle sql drop column if exists
SQL
0 vote220 views1 answer
Change default schema sql server
SQL
0 vote233 views2 answers
Sql join on wildcard
SQL
3 votes236 views1 answer
Apex set debug level
SQL
18 votes233 views2 answers
Find all tables containing column with specified name - MS SQL Server
SQL
0 vote240 views1 answer
My sql data file extention
SQL
2 votes232 views1 answer
Get hour from date sql
SQL
3 votes245 views1 answer
Oracle user privileges
SQL
2 votes264 views3 answers
How do I add a user to a postgres database? cli
SQL

Share