ADSM-L

Re: [ADSM-L] Formating SQL query

2009-10-15 08:58:45
Subject: Re: [ADSM-L] Formating SQL query
From: Michael Green <mishagreen AT GMAIL DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 15 Oct 2009 14:58:06 +0200
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?
>
>

<Prev in Thread] Current Thread [Next in Thread>