SQL Flashcards

1
Q

; (semicolon)

A

Semicolons are entered at the end of a query to indicate it is the end of the query.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q
  • (Asterisk)
A

Signifies “all”

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

SELECT

A

Indicates which columns to return.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

FROM

A

Indicates which columns to query.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

WHERE

A

Indicates the condition for a filter.

     Ex: WHERE country = ‘usa’
How well did you know this?
1
Not at all
2
3
4
5
Perfectly