Quote:
Originally Posted by camperjohn64
Let's say I have 10,000 videos, each video has a viewcount. To select them in order of viewcount:
SELECT * FROM videos ORDER BY viewcount;
[0] -> video A with 13,000 views
[1] -> video B with 12,824 views
[2] -> video C with 11,374 views
etc...
|
SELECT * FROM videos ORDER BY viewcount
DESC;
Result:
[0] -> video A with 13,000 views
[1] -> video B with 12,824 views
[2] -> video C with 11,374 views
SELECT * FROM videos ORDER BY viewcount
ASC;
Result:
[2] -> video C with 11,374 views
[1] -> video B with 12,824 views
[0] -> video A with 13,000 views