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
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.solonovi...@bkme.com wrote:
I am not very cool in SQL
...@bkme.com
Please consider the environment before printing this Email
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of
Michael Green
Sent: Thursday, October 15, 2009 3:58 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Formating SQL query
A year ago
15, 2009 8:49 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Formating SQL query
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
] Formating SQL query
Grigori,
I assume the sql*plus feature you use is the break statement which
by default does outlines on break columns.
Besides submitting sql and retrieving results sets, Sql*plus includes
a lot of report writer functions which are not strictly SQL.
So I don't know