When to use: SQL functions

0.0(0)
Studied by 0 people
call kaiCall Kai
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
GameKnowt Play
Card Sorting

1/4

encourage image

There's no tags or description

Looks like no tags are added yet.

5 Terms

1
New cards

Window Function

  • Top N per category

  • Rank

  • Running total

  • Previous/Next row

  • Compared to the group average


2
New cards

Subquery

  • Greater than the average

  • Not in

  • Exists

  • The highest


3
New cards

CTE

First find X, then using that...

4
New cards

Case When

categorize,” “label,” “high/medium/low”

5
New cards

JOIN

Customers who have no orders