I am using Moodle 6.6.4 anr latest version of CR for that.
I do need "java-sorting" so I wonder if "ORDER BY" not working is any kind of a Bug within CR??
Who ca help?
SELECT u.firstname, u.lastname FROM prefix_user u ORDER by u.lastname, u.firstname
Of course: Moodle 3.6.4, misstyped, sorry.
Used your SQL and sorting ON Result is: not working for me, sorting wrong:
what/where may be the faulty adjugement?