Filtering And Aggregating In SQL Flashcards
1
Q
What structure should all functions and commands follow?
A
Give all SQL commands and function their own lines.
2
Q
What should all the letters in a function and command be?
A
SQL commands and functions should in UPPERCASE letters.
3
Q
What symbols are the universal SQL indicators that a comment/note has been added?
A
/* Multiple Line comment is more universal */
4
Q
How do you write query headers?
A
Headers are just fancy-comments: /* ********************* ** NAME: Name of report ** DESC: Description of report ** AUTH: Name of Author ** REQ: Name of requester ** DATE: Date report published *********************** **Change History *********************** ** Version| Date | Author |Description **------------------------------------------ ** 1.1 |10/15/16|Pat Doe| Description of change************************** */
