如何用一条语句实现下面的三条的效果
select * from [] where id = 1;
select * from [] where id = 3;
select * from [] where id = 1;
用
select * from [] where id in(1,3,1)
结果只是1 3 而没有三条～
------解决方案--------------------
select * from [] where id = 1;
union all
select * from [] where id = 3;
union all
select * from [] where id = 1;
------解决方案--------------------
还是用union all
------解决方案--------------------
select * from [] where id in(1,3)
union all select * from [] where id =1