mysql读取表最后10条数据

读取表dailykt 里字段ts_code='300167.SZ’的　按照　trade_date　倒序最后10条数据，

select * from dailykt where ts_code='300167.SZ' order by trade_date  desc limit 10 ;