• amki@feddit.de
    link
    fedilink
    English
    arrow-up
    16
    ·
    1 year ago

    The implied difference is if someone or even you know how the algorithm works, which for “new” is relatively straightforward.

    • drcobaltjedi@programming.dev
      link
      fedilink
      English
      arrow-up
      4
      ·
      edit-2
      1 year ago

      Yeah

      SELECT TOP(100) * FROM POSTS ORDER BY DATEPOSTED

      Is a relatively straight forward command to a database and hell, I’m guessing extremely readable by your average Joe.

      • anlumo@feddit.de
        link
        fedilink
        English
        arrow-up
        3
        ·
        1 year ago

        If you’re talking SQL, it would be SELECT * FROM posts ORDER BY dateposted LIMIT 100.

        • drcobaltjedi@programming.dev
          link
          fedilink
          English
          arrow-up
          1
          ·
          1 year ago

          There are a lot of flavors of SQL each with their own syntax. I’ve been using Microsoft’s SQL now for 3 years and the syntax I used is correct for that.