在单个记录上返回多行

分类: 技术问答 • 2022-06-04 18:49:22

问题描述：

我需要检索此结果:

ROW1.id | ROW2.id | ROW3.id | ROW4.id
   1    |    2    |    3    |    4

从结果select * from Table开始:

id | value
1  | sample1
2  | sample2
3  | sample3
4  | sample4

有什么主意吗?

谢谢，安德里亚

答

您可以执行以下操作:

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

在单个记录上返回多行

相关推荐