About SQL statement removing duplicates method a, there are cases of the table: kuid dalei zhuanye guanjianchi neirong001 fa minfa hetong text1002 fa minfa hetong text2003 fa minfa hetong text3004 fa minfa jingzheng text4005 fa minfa jinghzneg text5006 fa minfa jingzheng text6007 fa minfa qingxiao text7008 fa minfa qingxiao Text8009 fa Minfa qianxiao text9
Requirements: All contents of all zhuanye equals MINFA (repeated only one): I want the result is ID dairong001 fa Minfa Hetong Text1004 fa Minfa Hetong text4007 fa Minfa Hetong Text7
How can I do it! Answer is such a Select * from kuwhere (ID in (Cast (Cast (Cast (Cast (Cast (Cast (Cast (ID (Id (Cast (Cast (Cast (Cast (Cast (ZhuangE = 'Minfa') Group by Guanjianchi))
