Please enable JavaScript.

Coggle requires JavaScript to display documents.

SQL (operations & operators (-expr, +expr, expr1 + expr2, expr1 -…

- - - - 'A%'
        
        ‘Anonymous’, ‘AC/DC’
      - '%in%'
        
        'in', 'inch', 'Pine', 'linchpin', 'lynchpin'
    - - 'Qua__'
        
        'Quack', 'Quaff'
      - '_re%'
        
        'Tree', 'area', 'fret', 'fretful' и 'freeze'
- - - - SELECT
        title_id,
        pubdate
        FROM titles
        WHERE EXTRACT(YEAR FROM pubdate)
        BETWEEN 2001 AND 2002
        AND EXTRACT(MONTH FROM pubdate)
        BETWEEN 1 AND 6
        ORDER BY pubdate DESC;
    - - SELECT
        CURRENT_DATE AS "Date",
        CURRENT_TIME AS "Time",
        CURRENT_TIMESTAMP AS "Timestamp";
  - - - CASE
        WHEN expr1 IS NOT NULL THEN expr1
        WHEN expr2 IS NOT NULL THEN expr2
        ELSE expr3
        END
- - - - ORDER BY
        
        DESC
        
        ASC
      - DISTINCT
      - AS
      - JOIN
      - HAVING
      - GROUP BY