3.6 Subqueries

0.0(0)
studied byStudied by 0 people
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
Card Sorting

1/3

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.

4 Terms

1
New cards

subquery / nested query / inner query

a query within another SQL query.

precedence order is higher. PEDMAS

2
New cards

Notation

SELECT *

FROM table1

WHERE Percentage IN

(SELECT Percentage

FROM table1

WHERE column_name = ‘ABW’);

3
New cards

alias

temporary name assigned to a column or table.

4
New cards

AS

  • temporary name assigned to a column or table.

  • The AS keyword follows a column or table name to create an alias.