Ch7 SQL

Question 1

What is the syntax for a SELECT statement?

Answer 1

SELECT columnlist
FROM tablelist
[WHERE condidtionlist]
[GROUP BY columnlist]
[HAVING conditionlist]
[ORDER BY columnlist [ASC | DESC] ] ;

Question 2

What is a view?

Answer 2

A view is a virtual table based on a SELECT query

Question 3

List three logical operators.

Answer 3

NOT, AND, OR