Clauses in MySQL

Quiz
•
Computers
•
12th Grade
•
Medium

Prathima Agraharapu
Used 23+ times
FREE Resource
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
Create a free account and access millions of resources
Similar Resources on Wayground
15 questions
SQL Order Group Distinct Aggregate Nested Having

Quiz
•
12th Grade
10 questions
Honors Marketing Vocabulary #2

Quiz
•
9th - 12th Grade
10 questions
Technical Terms - Hardware (A-Z) - CRT Monitors

Quiz
•
12th Grade
10 questions
Quiz - Ls.4 - Advanced Features of Word Processor(Part 2)

Quiz
•
4th Grade - Professio...
15 questions
MS Paint Quiz Ch5

Quiz
•
3rd Grade - University
10 questions
Technical Terms - Internet (A-Z) - Influencer

Quiz
•
12th Grade
10 questions
Technical Terms - Internet (A-Z) - Botnet

Quiz
•
12th Grade
10 questions
SQL- Join, Group by, having

Quiz
•
9th - 12th Grade
Popular Resources on Wayground
10 questions
Video Games

Quiz
•
6th - 12th Grade
20 questions
Brand Labels

Quiz
•
5th - 12th Grade
15 questions
Core 4 of Customer Service - Student Edition

Quiz
•
6th - 8th Grade
15 questions
What is Bullying?- Bullying Lesson Series 6-12

Lesson
•
11th Grade
25 questions
Multiplication Facts

Quiz
•
5th Grade
15 questions
Subtracting Integers

Quiz
•
7th Grade
22 questions
Adding Integers

Quiz
•
6th Grade
10 questions
Exploring Digital Citizenship Essentials

Interactive video
•
6th - 10th Grade