MORE QUERIES Flashcards
YOKO NA BRO
ALL QUERIES IN MS ACCESS ARE CONVERTED, IN THE BACKGROUND
STRUCTURE QUERY LANGUAGE
MOST DATABASE APPLICATIONS USE
SQL (STRUCTURE QUERY LANGUAGE)
IMPLEMENTATIONS OF SQL THAT ARE ROOTED TO THE ORIGINAL ONE AND EACH ONE IS CALLED
DIALECT
EACH OF THESE HAS ITS OWN VARIATIONS, SO THERE WILL BE DIFFERENCES IN THE CODE
DIALECT
THE ITEMS ENCLOSED ([])
SQUARE BRACKETS
OPTIONAL
SQUARE BRACKETS
({})
ENCLOSED IN BRACES
REQUIRED IN A SELECT QUERY
ENCLOSED IN BRACES
SELECT AND FROM CLAUSE ARE REQUIRED
IN SELECT QUERY
YOU TO PICK AMONG GIVEN OPTIONS
A VERTICAL BAR ( I )
YOU HAVE THE OPTION TO SHOW ALL RECORDS BY PLACING
ASTERISK (*)
Indicates repetition of an item that is optional and may be discarded or seen more than once
ELLIPSE
IT IS NOT CASE-SENSITIVE
SQL
RESERVED WORDS WILL BE IN
UPPERCASE
USER-DEFINED NAMES IS IN
LOWERCASE
EACH CLAUSE IS PLACED ON A
NEW LINE FOR CLARITY
IT FOLLOWS BY
A TABLE OF RESERVED WORDS AND DESCRIPTION
USED FOR GIVING ALIASES OR ALTERNATIVE
NAMES TO COLUMN
AS
INDICATES THE TABLES THAT WILL BE USED IN THE QUERY
FROM
FILTERS THE RECORDS BASED ON THE SPECIFIED QUERY
WHERE
GROUPS RECORDS WITH THE SAME FIELD VALUE
GROUP BY
WORKS LIKE WHERE BUT APPLIES ONLY TO GROUPS
HAVING
INDICATES HOW THE FIELDS WILL BE SORTED
ORDER BY