Clauses in MySQL

salary between 1000 and 30000

• where

• group by

• having

• none

group by is used to

• group similar records

• group null values only

• to add the records

• to delete the records

aggregate function

• instr()

• min()

• date()

• pow()

aggregate functions are applied on multiple rows and they generate single value

• True

• False

having is used only when

• string functions are there

• numeric functions are there

• aggregate functions are there

• date functionsa re there

average salary

• distinct

• where

• avg(sal)

• group by

number of students under each grade

• where

• group by

• having

• none

grades with total number of students less than 100

• where & group by

• where

• having

• group by & having

to order the table in descending for each department

• group by & order by

• group by & having

• group by & where

• group by

order by and group by are same

• True

• False