sql server mseq: Grouping by Distinct -- sql server mseq

Grouping by Distinct

PML
11/17/2005 5:26:05 AM

sql server mseq: Hi,

I have 2 columns of data, one has an Agent code and the other has
information about the Agent. There are duplicates of the Agent code in the
1st column, but different info in the second. For example:

Col 1 Col 2
Agent 1 Data 1
Agent 1 Data 2
Agent 1 Data 3
Agent 2 Data 4
Agent 2 Data 5

Is there a way to only show the Agent once without duplicating it? I dont
want to sum or count anything, I just want to show the data like this:

Agent 1 Data 1
Data 2
Data 3
Agent 2 Data 4
Data 5

Does anyone know if this grouping is possible?

Thanks,

Re: Grouping by Distinct

Steve Kass
11/17/2005 8:56:02 PM

What you describe is more like a report than a query
result, but you can produce reports in SQL. One way
to do it is like this:

select
Col1, Col2
from (
select
Col1 as hidden1, Col1,
min(Col2) as hidden2, min(Col2) as Col2
from T
group by Col1
union all
select
Col1, '', Col2, space(2) + Col2
from T
where Col2 <> (
select min(Col2) from T as Tm
where Tm.Col1 = T.Col1
)
) T
order by hidden1, hidden2

-- Steve Kass
-- Drew University

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server mseq group.