/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 vote350 views1 answer
Work around for mutating problem in Oracle Triggers. Please check it out.
SQL
0 vote358 views1 answer
Sql quary intervewi question
SQL
0 vote368 views1 answer
GROUP BY postgres
SQL
1 vote331 views1 answer
Postgres convert exisiting column to text
SQL
2 votes325 views1 answer
Oracle number to percentage
SQL
3 votes332 views3 answers
Mysql order by list
SQL
1 vote347 views1 answer
How to lock table in mysql
SQL
0 vote370 views1 answer
Oracle insert single quote in string
SQL
1 vote352 views1 answer
Postgresql how to show table names
SQL
5 votes386 views1 answer
Oracle get ddl
SQL

Share