Ch7 SQL Flashcards

1
Q

What is the syntax for a SELECT statement?

A
SELECT columnlist
FROM tablelist
[WHERE condidtionlist]
[GROUP BY columnlist]
[HAVING conditionlist]
[ORDER BY columnlist [ASC | DESC] ] ;
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What is a view?

A

A view is a virtual table based on a SELECT query

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

List three logical operators.

A

NOT, AND, OR

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