Search Header Logo

Clauses in MySQL

Authored by Prathima Agraharapu

Computers

12th Grade

Used 23+ times

Clauses in MySQL
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

10 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

salary between 1000 and 30000

where

group by

having

none

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

group by is used to

group similar records

group null values only

to add the records

to delete the records

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

aggregate function

instr()

min()

date()

pow()

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

True

False

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

having is used only when

string functions are there

numeric functions are there

aggregate functions are there

date functionsa re there

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

average salary

distinct

where

avg(sal)

group by

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

number of students under each grade

where

group by

having

none

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?