如何撰寫SQL敘述達到列出某一欄位的值重複兩次以上的資料 Sql='select field1 ,field2 from tablename group by field1 order by field1' 如此會將field1之群組全列出來,但我只要該field1值重複出現兩次以上才列 是否有辦法只一SQL即可達到

引言: 如何撰寫SQL敘述達到列出某一欄位的值重複兩次以上的資料 Sql='select field1 ,field2 from tablename group by field1 order by field1' 如此會將field1之群組全列出來,但我只要該field1值重複出現兩次以上才列 是否有辦法只一SQL即可達到

用次查詢SELECT 內有SELECT的方法, 先試試看,不行再問 ～～～Delphi K.Top討論區站長～～～

select field1 from tablename group by field1 having count(field1)>=2 order by field1

引言: select field1 from tablename group by field1 having count(field1)>=2 order by field1

好..好..耶!簡短明潦! ～～～Delphi K.Top討論區站長～～～

引言: select field1 from tablename group by field1 having count(field1)>=2 order by field1

謝謝你的回覆,不過有沒有其他方式,因為要其明細 select field1,field2,... from tablename where field1= {select field1 from tablename group by field1 having count(field1)>=2} order by field1

若field1是key，則 select * from tablename a, (select field1 from tablename group by field1 having count(field1)>=2) b where a.field1=b.field1