数据库里有如下数据:person表
id name
1 zhangsan
2 lisi
select * from person where id in (1,2,2,2,2);
以上查询只能得到 1,2的数据,如下
id name
1 zhangsan
2 lisi
我想得到重复的2的数据,如下,该怎么做啊谢谢
id name
1 zhangsan
2 lisi
2 lisi
2 lisi
2 lisi
id name
1 zhangsan
2 lisi
select * from person where id in (1,2,2,2,2);
以上查询只能得到 1,2的数据,如下
id name
1 zhangsan
2 lisi
我想得到重复的2的数据,如下,该怎么做啊谢谢
id name
1 zhangsan
2 lisi
2 lisi
2 lisi
2 lisi
union all
select * from person where id =2
union all
select * from person where id =2
union all
select * from person where id =2
union all
select * from person where id =2
select
}