select * from wloldnew
where oldcode in (121050109,121050109,121050110,121050110,121050109.);请教个问题,我想让这个查询返回重复行,如何操作呢默认的自动把重复行过滤掉了,有什么办法能返回重复行吗?
where oldcode in (121050109,121050109,121050110,121050110,121050109.);请教个问题,我想让这个查询返回重复行,如何操作呢默认的自动把重复行过滤掉了,有什么办法能返回重复行吗?
select * from wloldnew
where oldcode = 121050109
union all
select * from wloldnew
where oldcode = 121050109
union all
select * from wloldnew
where oldcode = 121050110
....