求一条SQL语句！

Question

   在YP_YPGGD里面得到满足条件的数据!
   条件
    YPPM,YPSPM,YPJX,YPDW,HLDW为一样的数据！
   

Answer 1

不会是
select 
* 
from 
YP_YPGGD
where
YPPM=YPSPM=YPJX=YPDW=HLDW
吧  没看懂

Answer 2

SELECT * FROM TB T WHERE 
EXISTS(SELECT 1 FROM TB WHERE YPPM=T.YPPM AND YPSPM=YPSPM AND YPJX=T.YPJX AND YPDW=T.YPDW AND HLDW=T.HLDW AND ID<>T.ID)???

Answer 3

select * from  YP_YPGGD
where YPPM=YPSPM=YPJX=YPDW=HLDW

Answer 4

六味地黄丸 9 24 22 9 六味地黄丸 lwdhw                                             
六味地黄丸 14 37 1 14 六味地黄丸 lwdhw                                             
知柏地黄丸 14 24 22 14 知柏地黄丸 zbdhw                                             
知柏地黄丸           14 24 22 14 知柏地黄丸           zbdhw                                             
补中益气丸           14 24 22 14 补中益气丸           bzyqw                                             
补中益气丸           14 24 22 14 补中益气丸           bzyqw                                             
归脾丸 14 24 22 14 归脾丸 gpw                                               
归脾丸               14 24 22 14 归脾丸               gpw                                               
黄氏响声丸 14 37 12 14 黄氏响声丸 hsxsw                                             
黄氏响声丸           14 37 1 12 黄氏响声丸           hsxsw                                             
杞菊地黄丸 14 37 1 14 杞菊地黄丸 qjdhw                                             
杞菊地黄丸           9 24 1 22 杞菊地黄丸           qjdhw                                             
大活络丸 9 37 1 12 大活络丸 dhlw                                              
  只要相同的数据！

Answer 5

select YPPM,YPSPM,YPJX,YPDW,HLDW from YP_YPGGD group by YPPM,YPSPM,YPJX,YPDW,HLDW having count(*)>1

Answer 6

--这样?
----------------------------------------------------------------
-- Author  :fredrickhu(我是小F，向高手学习)
-- Date    :2009-08-31 10:44:18
-- Verstion:
--      Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86) 
-- Nov 24 2008 13:01:59 
-- Copyright (c) 1988-2005 Microsoft Corporation
-- Developer Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
--
----------------------------------------------------------------
--> 测试数据：[tb]
if object_id('[tb]') is not null drop table [tb]
go 
create table [tb]([col1] varchar(10),[col2] int,[col3] int,[col4] int,[col5] int,[col6] varchar(10),[col7] varchar(5))
insert [tb]
select '六味地黄丸',9,24,22,9,'六味地黄丸','lwdhw' union all
select '六味地黄丸',14,37,1,14,'六味地黄丸','lwdhw' union all
select '知柏地黄丸',14,24,22,14,'知柏地黄丸','zbdhw' union all
select '知柏地黄丸',14,24,22,14,'知柏地黄丸','zbdhw' union all
select '补中益气丸',14,24,22,14,'补中益气丸','bzyqw' union all
select '补中益气丸',14,24,22,14,'补中益气丸','bzyqw' union all
select '归脾丸',14,24,22,14,'归脾丸','gpw' union all
select '归脾丸',14,24,22,14,'归脾丸','gpw' union all
select '黄氏响声丸',14,37,12,14,'黄氏响声丸','hsxsw' union all
select '黄氏响声丸',14,37,1,12,'黄氏响声丸','hsxsw' union all
select '杞菊地黄丸',14,37,1,14,'杞菊地黄丸','qjdhw' union all
select '杞菊地黄丸',9,24,1,22,'杞菊地黄丸','qjdhw' union all
select '大活络丸',9,37,1,12,'大活络丸','dhlw'
--------------开始查询--------------------------
select 
  col1,col2,col3,col4,col5,col6,col7 
from 
  tb t 
group by  
  col1,col2,col3,col4,col5,col6,col7
having 
  count(1) >1----------------结果----------------------------
/* col1       col2        col3        col4        col5        col6       col7
---------- ----------- ----------- ----------- ----------- ---------- -----
补中益气丸      14          24          22          14          补中益气丸      bzyqw
归脾丸          14          24          22          14          归脾丸          gpw
知柏地黄丸      14          24          22          14          知柏地黄丸      zbdhw(3 行受影响)*/