/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

2 votes162 views1 answer
Find column in all stored procedures sql server
SQL
0 vote149 views1 answer
Query for backup a database at another location in file system
SQL
1 vote145 views1 answer
Oracle sql first day of year
SQL
0 vote130 views1 answer
Sql select most frequent value in group
SQL
0 vote133 views1 answer
Sql join on a subquery
SQL
0 vote141 views1 answer
Postgresql not in alternative
SQL
3 votes138 views2 answers
Postgres show table schema
SQL
8 votes142 views1 answer
How to check mysql version in xampp
SQL
0 vote153 views1 answer
How to insert same table data using mysql query
SQL
0 vote145 views1 answer
Create table with float datatype in sql server
SQL

Share