Go on. Explore!

lvl 0 • 0 xp

lvl 1

Home Market Decks Interests

MySQL SELECT

memorize.ai (lvl 286)

(0)

9 cards

()

Section 1

Preview this deck

Does the SELECT operator need to be the same as GROUP BY

Front

1 / 9

SQL

0.0

0 reviews

5			0
4			0
3			0
2			0
1			0

Active users

All-time users

Favorites

Last updated

7 years ago

Date created

Mar 1, 2020

Cards (9)

Section 1

(9 cards)

Does the SELECT operator need to be the same as GROUP BY

Front

YES

Back

When to use HAVING vs WHERE in SELECT

Front

When you have a COUNT

Back

Is HAVING COUNT an aggregate

Front

YES, because of count

Back

Should you use WHERE with aggregate functions

Front

NO, you should use HAVING and GROUP BY

Back

What is the order of SELECT queries ? LIMIT, FROM, WHERE, SELECT, GROUP BY, HAVING, ORDER BY

Front

1. SELECT 2. FROM 3. WHERE 4. GROUP BY 5. HAVING 6. ORDER BY 7. LIMIT

Back

What operator do you need to ad for Alias?

Front

AS

Back

With general conditions should you use HAVING or WHERE

Front

WHERE

Back

With HAVING can you have both aggregate and non aggregate?

Front

NO

Back

What is the rule when working with Aggregate functions?

Front

Use GROUP BY and HAVING

Back