/SQL/Sql interview query questions

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

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

0

Source: edureka.co

Similar codes

0 vote108 views1 answer
Query only first letter string
SQL
1 vote111 views1 answer
Sqlalchemy order_by
SQL
0 vote99 views2 answers
Sql day from datetime
SQL
0 vote101 views1 answer
Sql select rows between 1000 and 2000
SQL
0 vote110 views1 answer
Mysql change innodb to myisam
SQL
0 vote103 views2 answers
Zsh: command not found: mysq
SQL
0 vote110 views1 answer
Sqlites studio red exclamation mark when poening databse
SQL
0 vote102 views1 answer
Mysql search like but first exact match
SQL
3 votes114 views1 answer
Unsigned int in mysql
SQL
2 votes66 views1 answer
Oracle current date without time
SQL

Share