Limiting rows

[Luk1]

I'm trying to figure a way to combine these 3 queries into a single one.

select top 48 * from table1 where column1 = 1
select top 48 * from table1 where column1 = 2
select top 48 * from table1 where column1 = 3

Anybody know of a way that would make it possible?

 

[stsuing]

The UNION operator can be used between queries to combine their results into a single result set.

 

[MeanGreen]

To elaborate what stsuing has said:

select top 48 * from table1 where column1 = 1
UNION
select top 48 * from table1 where column1 = 2
UNION
select top 48 * from table1 where column1 = 3


Good Luck!