As you can see the roworder is reversed with John now appearing in the first row.
正如您看到的,行顺序变了,现在John出现在第一行。
2
The roworder in the query elements table in which columns are defined determines their left to right sequence within the order BY clause, which in turn determines their sorting priority.