很难的问题，高手请帮忙

[garry2000]

select * from usercompanyproduct where ucid in(4,4,4,9,7)
这是我的一条语句，我想让他显示五条，可是只能显示三条，可不可以让他显示五条

[dawugui]

select * from usercompanyproduct where ucid = '4'
union all
select * from usercompanyproduct where ucid = '4'
union all
select * from usercompanyproduct where ucid = '4'
union all
select * from usercompanyproduct where ucid = '7'
union all
select * from usercompanyproduct where ucid = '9'

[Andy-W]

当然只能显示3条了,因为ucid =4存在重复.
要是想显示多条,只有重新构造查询语句了,可以考虑使用动态SQL语句

[jinanjiang]

学习中