mysql中的常用查询持续更新中

（一）两个字段的排序查询

select * from (select * from admin order by admin_id asc) as t order by t.admin_group_id asc;