Resolved: What is the second rule when organizing records when ORDER BY (for ex. first_name) is used and more people have same first_name?
Hello.
What is the second rule when organizing records when ORDER BY (for ex. first_name) is used and more people have same first_name?
Is there some rule or is it random?
Thanks.
Cheers,
Maros J
1 answers ( 0 marked as helpful)
Hi Maros!
Thanks for reaching out.
In this particular lecture, we only provide an example. Otherwise, you can use the primary key when ordering the data, for instance. Alternatively, depending on the situation, you could add a second field like this:
Best,
Martin
...Hope this helps.
ORDER BY first_name, last_name DESC;
Best,
Martin