用union all
假設列名分別為 col1 cola colb...
select col1,cola
from tabname
where ...
union all
select col1,colb
select col1,colc
select col1,cold
select col1,cole
select col1,colf
用union all
假設列名分別為 col1 cola colb...
select col1,cola
from tabname
where ...
union all
select col1,colb
from tabname
where ...
union all
select col1,colc
from tabname
where ...
union all
select col1,cold
from tabname
where ...
union all
select col1,cole
from tabname
where ...
union all
select col1,colf
from tabname
where ...