RE: SQL basic questions

["Wilt, Charles" <CWilt@xxxxxxxxxxxx>]

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.


HTH,

Charles Wilt
--
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121
  

> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx 
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of 
> steema@xxxxxxxxxxxxx
> Sent: Monday, April 24, 2006 9:20 AM
> To: midrange-l@xxxxxxxxxxxx
> Subject: SQL basic questions
> 
> HI I want to be able to use the Select Distinct feature on a 
> key level.
> I have a file w/ Acct and model #, and I want to list only 
> one model per
> acct. instead when i do Select Distinct currently, I get many per
> Acct/model. Is there a way to make this break on the key?
> 
> 
> -- 
> This is the Midrange Systems Technical Discussion 
> (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
> 
>