Question

my sql select where in排序问题

select st_org_id from khbm_group_mapping where st_group_id = '299b18b7-bd22-472e-a7e9-053233085c15'，结果：

select st_org_name,st_org_id from info_org where st_org_id in
(select st_org_id from khbm_group_mapping where st_group_id = '299b18b7-bd22-472e-a7e9-053233085c15')，结果：

这个查询结果顺序给乱了，我想根据st_org_id进行排序，这个sql该怎么写呢。





Answer 1

查询语句最后加上 order by st_org_id 就可以了，默认升序。

Answer 2

select st_org_id from khbm_group_mapping where st_group_id = '299b18b7-bd22-472e-a7e9-053233085c15' order by st_org_id 按st_org_id升序排列
select st_org_id from khbm_group_mapping where st_group_id = '299b18b7-bd22-472e-a7e9-053233085c15' order by st_org_id 按st_org_id降序排列
潮安县彩塘镇顺驰不锈钢制品厂竭诚为您服务