SQL Basics

0.0(0)
studied byStudied by 0 people
0.0(0)
full-widthCall Kai
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
GameKnowt Play
Card Sorting

1/18

encourage image

There's no tags or description

Looks like no tags are added yet.

Study Analytics
Name
Mastery
Learn
Test
Matching
Spaced

No study sessions yet.

19 Terms

1
New cards

SELECT

Selects a column from the table (can select more than one column by dividing the listed columns with “,”)

2
New cards

FROM

Specifies the table you’re pulling from

3
New cards

WHERE

Specifies the specific rows you are pulling that meet a certain criteria

4
New cards

AND/OR

Used to combine multiple criteria

5
New cards

ORDER BY

Commands the manner in which the results will be arranged

6
New cards

LIMIT

Limits the number of the results

7
New cards

DISTINCT

Removes duplicate results.

8
New cards

COUNT(x)

Counts the number of rows

9
New cards

SUM()

Adds up all the numeric values in a column

10
New cards

AVG()

Calculates the average value

11
New cards

MIN()

Finds the smallest value

12
New cards

MAX()

Finds the largest value

13
New cards

GROUP BY

Aggregates data based on a specified column

14
New cards
15
New cards
16
New cards
17
New cards
18
New cards
19
New cards