ÎÒÏëд¸ö²éѯÓï¾äÊǸù¾ÝÌõ¼þ·µ»Ø³ö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
¹ØÓÚSQL Server Mobile Edition ÓÃMicrosoft SQL Server2005 Management Studio Express9.00.3042.00´´½¨SQLCEÊý¾Ý¿âsqlmobile.sdf ÔÚmobileϵͳÖÕ¶ËÉÏÓÃSQL Server Mobile Edition3.0Äܲ鿴sqlmobile.sdfÀï±íÊý¾Ý ......