/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 vote373 views1 answer
Which takes more space in a database a datetime or separate date and time columns?
SQL
0 vote390 views1 answer
Mariadb set vertical output format
SQL
0 vote354 views1 answer
Psql use query result convert Decimal python numpy psycopg2
SQL
0 vote474 views1 answer
Sp help text in postgresql
SQL
0 vote362 views2 answers
Mysql regexp match word
SQL
2 votes371 views1 answer
Query to find table size in oracle 12c
SQL
7 votes413 views3 answers
Sql update where id
SQL
2 votes406 views2 answers
Mysql bidirectional composite primary key
SQL
22 votes363 views3 answers
Remove all records from table mysql
SQL
0 vote335 views1 answer
Difference between cross apply and inner join
SQL

Share