如何用一条语句实现下面的三条的效果
如何用一条语句实现下面的三条的效果
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
