SELECT <column> from table group by <column> having count(*) > 1 Albert
On 11/6/2014 10:24 AM, Arthur Krauss wrote:
John - I would like to choose, select, project, etc. those records in a table that have a single column in which the same value appears more than once. Simply using distinct doesn't work, of course, since that would also select all the "1's." Can you offer a suggestion? Thanks, Yours truly, Woodlyn Associates, LLC Arthur N. Krauss, CPA, CGMA President 267-352-3522 (direct) 215-322-5600 x205 267-568-2641 (fax) [email protected]
