Perfect. 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] -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Albert Berry Sent: Thursday, November 06, 2014 12:35 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Select, etc. question 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] > > >
