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] ] ;
2
Q
What is a view?
A
A view is a virtual table based on a SELECT query
3
Q
List three logical operators.
A
NOT, AND, OR