all groups > sql server mseq > july 2003 >
You're in the

sql server mseq

group:

find a set of common values for a group of records


find a set of common values for a group of records Pam Downey
7/22/2003 1:48:20 PM
sql server mseq:
I need some help knowing where to start of a query. I
have a set of records. Each record has an account number
and a period. I am interested in a particular set of
account numbers such as acct number 1 and acct number 2.
For that particular set of account numbers I need to find
the list of periods that is common to that set of account
numbers. Any information on how to get started would be
appreciated for instance can this be done with group by or
an outer join etc. Thanks for your help.
Re: find a set of common values for a group of records Ray Higdon
7/22/2003 2:29:39 PM
Unless it is performing an aggregation, you should be able to use Order
by account number.

HTH

Ray Higdon MCSE, MCDBA, CCNA

*** Sent via Developersdex http://www.developersdex.com ***
AddThis Social Bookmark Button