odbtools/odbctest/mql/basic/10basic/51orderby.mql

select id,v_chars as "文字" from /test/foo order by "文字"
/**
output()
**/
;

select count(*), aa.v_chars as "文字" from /test/foo aa
group by aa.v_chars order by "文字" desc
/**
output()
match('文字','d',count,4)
match('文字','c',count,3)
match('文字','b',count,2)
match('文字','a',count,1)
**/
;

select count(*), aa.v_chars as "文字" from 
(select * from /test/foo) aa
group by aa.v_chars order by "文字" desc
/**
output()
match('文字','d',count,4)
match('文字','c',count,3)
match('文字','b',count,2)
match('文字','a',count,1)
**/
;