- 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