SQL basic questions

["Smith, Dave" <dsmith@xxxxxxxxx>]

Select Distinct
Acct, Model
>From TableName

What am I missing?

David Smith
IT Consultant

>>-----Original Message-----
>>From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-
>>bounces@xxxxxxxxxxxx] On Behalf Of midrange-l-request@xxxxxxxxxxxx
>>Sent: Monday, April 24, 2006 10:40 AM
>>To: midrange-l@xxxxxxxxxxxx
>>Subject: MIDRANGE-L Digest, Vol 5, Issue 852
>>from: steema@xxxxxxxxxxxxx
>>subject: RE: SQL basic questions
>>
>>I did what I needed the tedious way, 2 programs, 1 workfile.
>>
>>lets say you have an account.
>>
>>12806  it has stores and models
>>acct    store    model
>>12806   0001     AAA
>>12806   0002     AAA
>>
>>I just want 12806 AAA don't care about the store.
>>
>>I would rather do this in one SQL statement.
>>
>>> How do you expect to pick the one model to display?
>>>
>>> Easiest would be to use min/max
>>>
>>> Select acct, min(model) from mytable
>>> Group by acct
>>>
>>> If you want the "first" model with a given account, that would be
harder
>>> to do but it can be done.  The key would be determining the
definition
>>> of first you want to use.
>>>
**************