且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

在单个记录上返回多行

更新时间:2023-12-04 13:14:16

您可以执行以下操作:

select 
 (select id from table X where X.something = 123) as row1Id,
 (select id from table X where X.something = 456) as row2Id,
 (select id from table X where X.something = 789) as row3Id