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 <[email protected]> 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? > >
