Query with multiple SELECT statements

Question

Is it possible to make a query containing 4 SELECT statements where each result is placed in its own column? How?

I'm currently sitting with 4 queries that I need to somehow combine into 1 and I've tried using UNION but it seems to put the results in the same column, just a new row.

Thanks.

Try to follow this pattern: select 1 as one, (select 2 from dual) as two from dual — wxyz
– wxyz, Commented Nov 12, 2012 at 12:36

RichardTheKiwi · Accepted Answer · 2012-11-12 12:36:07Z

2

If the SELECT statements each return a SCALAR result, i.e. single-row, single-column - then yo can just do this:

SELECT (select .... ) Column1,
       (select .... ) Column2,
       (select .... ) Column3,
       (select .... ) Column4;

answered Nov 12, 2012 at 12:36

RichardTheKiwi

108k28 gold badges206 silver badges269 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Morten Laustsen Over a year ago

Would this work different if I needed to use SUM in all SELECT statements?

RichardTheKiwi Over a year ago

No it wouldn't. It's still the same flat pattern.

Tim Schmelter · Accepted Answer · 2012-11-12 12:36:31Z

1

You can use sub-queries and a column alias:

SELECT (SELECT TOP 1 Col1 From dbo.Table2 WHERE Condition1)AS Col1
,      (SELECT TOP 1 Col1 From dbo.Table3 WHERE Condition2)AS Col2
FROM dbo.Table1

Using a Subquery in a T-SQL Statement

answered Nov 12, 2012 at 12:36

Tim Schmelter

462k79 gold badges720 silver badges981 bronze badges

Collectives™ on Stack Overflow

Query with multiple SELECT statements

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related