select * from mmsp213 a where a.mtr_no in (select mtr_no from mmsp213 group by mtr_no having count(mtr_no)>1) and price_date='2011-5-1'
这样查的 mtr_no 这一列没有一个是重复的 是怎么回事??
这样查的 mtr_no 这一列没有一个是重复的 是怎么回事??
解决方案 »
- 若输入为空,则此条件没有限制,即默认此条件中全体元组都可以查询,求此sql语句
- 关于将数据库备份到磁带上
- 联表删除问题?很有意思的
- 程序调用sql触发器问题
- 在A表中设置了主键ID为自动增量,为防止有二个以上用户同时插入记录,"Insert into TB WITH (ROWLOCK) (col1,col2) values (@col1,@col2)",
- 一个select语句count多个表的同一个字段问题~~
- 邹书中的一个问题 就是没看明白
- 急,sql2000的数据区不区分大小写?
- 您好,我想讨教一下数据库还原后登录出现故障的问题。
- 有关触发器的问题
- SQL语句charindex过滤记录的问题?
- 用sql server 2005
select * from mmsp213 a where a.mtr_no in (select mtr_no from mmsp213
where price_date='2011-5-1'
group by mtr_no having count(mtr_no)>1)
from mmsp213 a
where a.mtr_no in
(select mtr_no from mmsp213 group by mtr_no having count(mtr_no)=1) and price_date='2011-5-1'
FROM (SELECT *,ROW_NUMBER()over(PARTITION BY mtr_no ORDER BY mtr_no) AS row FROM mmsp213 WHERE price_date='2011-5-1')t WHERE row=1
price_date='2011-5-1'
--找重复记录的语句没错,估计是这里需要转换下,convert(datetime,'2011-5-1')
select * from mmsp213 a where a.price_date='2011-5-1' and a.mtr_no in (select mtr_no from mmsp213
where price_date='2011-5-1'
group by mtr_no having count(mtr_no)>1)
from
(select *,COUNT(mtr_no)OVER(PARTITION BY mtr_no) AS con from mmsp213 where price_date='2011-5-1' )t
WHERE con>1
select * from mmsp213 a where a.mtr_no in (select mtr_no from mmsp213 group by mtr_no having count(mtr_no)>1)