Please enable JavaScript.

Coggle requires JavaScript to display documents.

Query Tree - Coggle Diagram

- - - - Filters duplicated rows
    - - Can be omitted by spacing
      - Uppercase in default
      - Add "..." to fix header's case
    - - last_name || ' ' || first_name
    - - Can be implemented, but has weird name, so implement alias
  - - - ... AND ...
    - - (...,...,...)
    - - Wildcard Characters
        
        (_) - Any character in regEx
        
        (%) - Any character besides regEx
        
        n% - After regEx
        
        %n - Before regEx
        
        %n% - Between regEx
      - enclosed in single quote
      - ESCAPE '\' make wildcard symbols as actual regEx
      - Character Searching are case sensitive
    - - Unassigned, Unknown Value
      - Evaluate to NULL
      - display last in ASC, display first in DESC in default
      - Customize: NULL FIRST, NULL LAST
      - Condition Checking: IS NULL
    - - Customized by UPPER('...') or LOWER ('...')
      - Date default values: DD-Mon-YYYY
  - - - column header
      - column number