this post was submitted on 26 Aug 2023
1932 points (98.7% liked)

Technology

60301 readers
3402 users here now

This is a most excellent place for technology news and articles.


Our Rules


  1. Follow the lemmy.world rules.
  2. Only tech related content.
  3. Be excellent to each another!
  4. Mod approved content bots can post up to 10 articles per day.
  5. Threads asking for personal tech support may be deleted.
  6. Politics threads may be removed.
  7. No memes allowed as posts, OK to post as comments.
  8. Only approved bots from the list below, to ask if your bot can be added please contact us.
  9. Check for duplicates before posting, duplicates may be removed

Approved Bots


founded 2 years ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
[–] amki@feddit.de 16 points 1 year ago (1 children)

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

[–] drcobaltjedi@programming.dev 4 points 1 year ago* (last edited 1 year ago) (1 children)

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 3 points 1 year ago (1 children)

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

[–] drcobaltjedi@programming.dev 1 points 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.