6 thoughts on “book errata

  1. Aketi Jyuuzou

    In page 111,
    “select min(sal),max(sal) from emp” returns 2 rows.

    But without “group by” Query does not return 2 rows.
    I suppose this is a typo 😉

  2. Laurent Schneider Post author

    The maximum and minimum salary can be returned as a single row


    SELECT MIN(SAL),MAX(SAL) FROM EMP;
    MIN(SAL) MAX(SAL)
    --------- --------
    800 5000
    801

    damned microsoft word autocorrection… I will use vi for my next book !

Comments are closed.