• 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.