sql | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
+ 1

sql

If we use the order and assume the following The first column is numbers from 1 to 10 The second column is the names and we used the order by id and name ??? What is the benefit of ranking by name? Do you think it is needed? For the villains

20th Jan 2018, 1:26 AM
ahmed latef salih
ahmed latef salih - avatar
2 Answers
+ 17
what if 2 or more persons have the same number, then u need to order by number & then order by name ☺
20th Jan 2018, 4:09 AM
Gaurav Agrawal
Gaurav Agrawal - avatar
+ 9
Ordering by id and then by name would result in the same thing as ordering by id only, if each id is distinct.
20th Jan 2018, 2:34 AM
Hatsy Rei
Hatsy Rei - avatar