select last(s9) from root.cj2.jr*.result order by time desc this can work right. select last(s9) from root.cj2.jr*.result order by time asc this can't work right.