term1 Definition1term2 Definition2term3 Definition3
Please sign in to your Google account to access your documents:
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
Need help typing ? See our FAQ (opens in new window)
Please sign in to create this set. We'll bring you back here when you are done.
Discard Changes Sign in
Please sign in to add to folders.
Sign in
Don't have an account? Sign Up »
You have created 2 folders. Please upgrade to Cram Premium to create hundreds of folders!