sql ²éѯÓï¾ä.

±í½á¹¹ÊÇÕâÑù¡£
id EmpId SalayType SalayMoney

1  1 ÀàÐÍ1 300.00
2  1 ÀàÐÍ2 100.00
3  1 ÀàÐÍ3 300.00
4  2 ÀàÐÍ1 300.00
5  2 ÀàÐÍ2 100.00
6  2 ÀàÐÍ3 10.00

select EmpId from EmpGongZiReport group by EmpId

ÕâÀï·µ»Ø³ö1 2

ÎÒÏëд¸ö²éѯÓï¾äÊǸù¾ÝÌõ¼þ·µ»Ø³öid
±ÈÈç ÀàÐÍ1>200 ²¢ÇÒÀàÐÍ3 <20 ·µ»Ø³ö2 ¡£ÈçºÎд лл¡£

---

select empid from EmpGongZiReport where (SalayType='ÀàÐÍ1' and SalayMoney>200) and (SalayType='ÀàÐÍ3' and SalayMoney <20) group by empid

---

SQL code:

SELECT EmpID
from xx Where (SalyType='ÀàÐÍ1'and SalayMonet>'200') or (SalyType='ÀàÐÍ3'and SalayMonet<'20') Group by EmpId


²»ÖªµÀÕâÑùÊÔºÏÄã²»

---

ÉÏÃæÄǸö²»Ðа¡¡£¡£¡£²¢ÇҵĻ°¶¼²é²»³ö¡£

---

ÒýÓÃ

select empid from EmpGongZiReport where (SalayType='ÀàÐÍ1' and SalayMoney>200) and (SalayType='ÀàÐÍ3' and SalayMoney <20) group by empid

up

---

select empid from EmpGongZiReport where (SalayType='ÀàÐÍ1' and SalayMoney>200) or (SalayType='ÀàÐÍ3' and SalayMoney <20) group by empid
ÒªÓÃor²Å¶Ô£¬andµÄ»°Ò»¸öҲûÓÐ

---

Â¥Ö÷ÄãÏàҪʲô½á¹û£¿¶àÂÞÁÐһЩÊý¾Ý£¬½«²éѯ½á¹û¸ø³ö

---

...ÓÑÇ鶥һÏÂ
~~~

---

ÄãµÄÌõ¼