Log in Sign up
3 Matching Annotations
  1. Aug 2024
  2. stackoverflow.com stackoverflow.com
    Select first row in each GROUP BY group?
    2
    1. TylerRick 14 Aug 2024
      in Public
      ELECT DISTINCT ON (customer) id, customer, total FROM purchases ORDER BY customer, total DESC, id;
      SQL: distinct
    2. TylerRick 14 Aug 2024
      in Public
      SQL: distinct
    Visit annotations in context

    Tags

    • SQL: distinct

    Annotators

    • TylerRick

    URL

    stackoverflow.com/questions/3800551/select-first-row-in-each-group-by-group
  3. Jun 2021
  4. dba.stackexchange.com dba.stackexchange.com
    'Column reference is ambiguous' when upserting element into table
    1
    1. TylerRick 03 Jun 2021
      in Public
      Careful, Instead of != you may need to IS DISTINCT FROM operator which also compares NULL value
      distinction SQL: null values and = SQL: is distinct from
    Visit annotations in context

    Tags

    • SQL: null values and =
    • distinction
    • SQL: is distinct from

    Annotators

    • TylerRick

    URL

    dba.stackexchange.com/questions/161127/column-reference-is-ambiguous-when-upserting-element-into-table
Share:
Group. Only group members will be able to view this annotation.
Only me. No one else will be able to view this annotation.
Hypothes.is
  • About
  • Blog
  • Bioscience
  • Education
  • Jobs
  • Help
  • Contact
  • Terms of Service
  • Privacy Policy