/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 vote218 views1 answer
Comma seperated join mssql
SQL
0 vote231 views1 answer
Test database for sql
SQL
44 votes238 views6 answers
Rename command in sql
SQL
0 vote255 views1 answer
Stratified sampling sql
SQL
1 vote227 views1 answer
Join to find results not in another table
SQL
3 votes240 views2 answers
Mysql select database
SQL
0 vote211 views1 answer
How to remove default in mysql
SQL
1 vote238 views1 answer
Sql upsert
SQL
0 vote214 views1 answer
Downgrading sql localdb visual studio
SQL
7 votes214 views1 answer
Oracle set sequence value to max(id)
SQL

Share