{"rsdb":{"rid":"242515","subhead":"","postdate":"0","aid":"166980","fid":"57","uid":"1","topic":"1","content":"<div id=\"Article\"> \n <p>\u2013\u67e5\u8be2\u91cd\u590d\u6570\u636e<\/p> \n <pre class=\"brush:sql;\">\r\nselect tt.* from \u8868 tt where \u81ea\u5b9a\u4e49\u6761\u4ef6\r\nand tt.\u91cd\u590d\u5b57\u6bb5 in (select t.\u91cd\u590d\u5b57\u6bb5 from \u8868 t where \u81ea\u5b9a\u4e49\u6761\u4ef6 group by t.\u91cd\u590d\u5b57\u6bb5 having count(t.\u91cd\u590d\u5b57\u6bb5) &gt; 1) \r\n<\/pre> \n <p>\u2013\u67e5\u8be2\u91cd\u590d\u6570\u636e\u4e2did\u6700\u5c0f\u7684\u90a3\u4e2a<\/p> \n <pre class=\"brush:sql;\">\r\nselect tt.* from \u8868 tt where \u81ea\u5b9a\u4e49\u6761\u4ef6\r\nand tt.\u91cd\u590d\u5b57\u6bb5 in (select t.\u91cd\u590d\u5b57\u6bb5 from \u8868 t where \u81ea\u5b9a\u4e49\u6761\u4ef6 group by t.\u91cd\u590d\u5b57\u6bb5 having count(t.\u91cd\u590d\u5b57\u6bb5) &gt; 1) \r\nand tt.id in (select min(t.id) from \u8868 t where \u81ea\u5b9a\u4e49\u6761\u4ef6 group by t.\u91cd\u590d\u5b57\u6bb5 having count(t.\u91cd\u590d\u5b57\u6bb5) &gt; 1) <\/pre> \n<\/div>","orderid":"0","title":"Oracle\u5982\u4f55\u67e5\u8be2\u91cd\u590d\u6570\u636e\uff1f","smalltitle":"","mid":"0","fname":"\u6570\u636e\u5e93\u7f16\u7a0b","special_id":"0","bak_id":"0","info":"0","hits":"125","pages":"1","comments":"0","posttime":"2017-12-14 14:32:23","list":"1513233143","username":"admin","author":"","copyfrom":"","copyfromurl":"","titlecolor":"","fonttype":"0","titleicon":"0","picurl":"https:\/\/www.cppentry.com\/upload_files\/","ispic":"0","yz":"1","yzer":"","yztime":"0","levels":"0","levelstime":"0","keywords":"<A HREF='https:\/\/www.cppentry.com\/do\/search.php?type=keyword&keyword=Oracle' target=_blank>Oracle<\/A> <A HREF='https:\/\/www.cppentry.com\/do\/search.php?type=keyword&keyword=%C8%E7%BA%CE' target=_blank>\u5982\u4f55<\/A> <A HREF='https:\/\/www.cppentry.com\/do\/search.php?type=keyword&keyword=%B2%E9%D1%AF' target=_blank>\u67e5\u8be2<\/A> <A HREF='https:\/\/www.cppentry.com\/do\/search.php?type=keyword&keyword=%D6%D8%B8%B4' target=_blank>\u91cd\u590d<\/A> <A HREF='https:\/\/www.cppentry.com\/do\/search.php?type=keyword&keyword=%CA%FD%BE%DD' target=_blank>\u6570\u636e<\/A>","jumpurl":"","iframeurl":"","style":"","template":"a:3:{s:4:\"head\";s:0:\"\";s:4:\"foot\";s:0:\"\";s:8:\"bencandy\";s:0:\"\";}","target":"0","ip":"113.110.149.170","lastfid":"0","money":"0","buyuser":"","passwd":"","allowdown":"","allowview":"","editer":"","edittime":"0","begintime":"0","endtime":"0","description":"Oracle\u5982\u4f55\u67e5\u8be2\u91cd\u590d\u6570\u636e\uff1f","lastview":"1712985851","digg_num":"0","digg_time":"0","forbidcomment":"0","ifvote":"0","heart":"","htmlname":"","city_id":"0"},"page":"1"}