Sajeev Hegde

Sajeev Hegde

  • NA
  • 40
  • 5.1k

How SQL decide to return which records when I execute the following qu

Jul 16 2022 12:42 PM

Hello
How SQL decide to return which records when I execute the following query in my terminal? Is it randomly?

SELECT * FROM users LIMIT 100;

note: I did not use ORDER BY in my query.

A little bit about why I am asking this question: I just think how SQL store data. Does it save inserted data ascending based on createdAt?


Answers (1)