select * from Table inner join (select distinct field1,field2,field3 from Table)
as Table2 on Table.field1=Table2.field1 and Table.Field2=Table.Field2 and
Table.Field3=Table2.Field3
我贊同Francky的方法﹐只是應該:
SELECT * FROM ttt
WHERE ((fldn + fld2 + fld3 + fld4) IN
(SELECT MIN(fldn) + fld2 + fld3 + fld4 FROM ttt
GROUP BY fld2, fld3, fld4))
修正一下,加上当前的user_id(cur_user_id)
select opp.* from opp, customer cust
where opp.cust_id = cust.cust_id
and exists (select 'x' from customer_assign ca
where ca.user_id = cust.user_id
and IsParent(ca.user_id, cur_user_id));