Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
3 Cards in this Set
- Front
- Back
Select Statement |
1. Only required clause in a Select statement 2. Select columns can be: A. Literals(constants) B. Expressions C. Table columns D. Subqueries |
|
Logical Processing Order of Select Statement |
1. From 2. On 3. Join 4. Where 5. Group by 6. With Cube or With Rollup 7. Having 8. Select 9. Distinct 10. Order by 11. Top |
|
What is the Top clause |
Used to filter results according to the sorting specified in the order by clause |