Thank you very much, but this an answer on my question? Is it enough to remove 
distinct?

Grigori G. Solonovitch

Senior Technical Architect

Information Technology  Bank of Kuwait and Middle East  http://www.bkme.com

Phone: (+965) 2231-2274  Mobile: (+965) 99798073  E-Mail: G.Solonovitch AT bkme 
DOT com

Please consider the environment before printing this Email


-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
Michael Green
Sent: Thursday, October 15, 2009 3:58 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] Formating SQL query

A year ago I attended an introductory 5-day SQL*Plus course where we
were told that usage of 'distinct' is discouraged, use 'group' by
instead.

My 5¢.
--
Warm regards,
Michael Green



On Thu, Oct 15, 2009 at 2:49 PM, Grigori Solonovitch
<G.Solonovitch AT bkme DOT com> wrote:
> I am not very cool in SQL and I need help.
> I have query like "select distict a,b from c group by a,b"
> Response on this SQL query in  TSM Server is:
> A1 B1
> A1 B2
> A2 B3
> A2 B4
> A2 B5
> I would like to have:
> A1 B1
>     B2
> A2 B3
>     B4
>     B5
> I know exactly it is possible in Oracle SQL*Plus.
> Is it possible in TSM Server 5.5.3?
> Is it possible in TSM Server 6.1.2 (DB2)?
> What is the way, if possible?
>
>

Please consider the environment before printing this Email.

"This email message and any attachments transmitted with it may contain 
confidential and proprietary information, intended only for the named 
recipient(s). If you have received this message in error, or if you are not the 
named recipient(s), please delete this email after notifying the sender 
immediately. BKME cannot guarantee the integrity of this communication and 
accepts no liability for any damage caused by this email or its attachments due 
to viruses, any other defects, interception or unauthorized modification. The 
information, views, opinions and comments of this message are those of the 
individual and not necessarily endorsed by BKME."