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?
>
>
|