SQL DQL Test 1

select employees in descending order – salary
select all employees from Mumbai
select all employees having salary more than average salary
select sum of salary from table
select all unique address
select details, salary from table
(details should be concatenation of name and address)
select names of employees having max salary
select employees having 2nd max salary
count employees by address, order by employee count
e.g. select count(name,address) from employee
show count of employees from nagpur only
select all employees whose names starts or ends with vowels
find employees having max salary in particular city
select top 5 salaried employees
select 2^nd highest salaried employees
show cities having total salary more than 200000
Show all students who appeared for exam
show student, subject and total marks of students whose total marks are more than 80