- list all selling in 2019
- count all selling year wise order by selling
- select all selling in march month of year 2019
- count selling in 22 week of year 2020
- select all selling from 1st Feb 2019 to 31st Mar 2019
- select all customers who place orders in 2019
- select all customers from USA who placed order in 2019
- select all customers whose order is on hold
- select all customers who placed order in march month only
- select top 5 customers from USA (who has maximum orders from country USA)
Month: August 2022
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 2nd 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
