grouping sections

[TheDash]

Hello,

I have a query like select a, b, c from tab1
It results

10 100 1000
10 110 1100
10 120 1200
20 200 2000
20 210 2100
20 220 2200

Any idea how I can retrieve the data like this:

10 100 1000
110 1100
120 1200
20 200 2000
210 2100
220 2200

i.e the column a should only appear once....

Thanks in advance.

 

[karluk]

One way to do this is with the "lag" function, which allows you to monitor whether the value in the column "a" has changed from the previous row. That, in turn, enables you to decide whether to print or suppress "a" in the current row.

select decode(a-prev_a, 0, null, a), b, c from
  (select a, b, c, lag(a, 1, a-1) over (order by a, b, c) as prev_a
    from tab1
  )

 

[taupirho]

if its just for display purposes you can use the sqlplus break command


eg

break on a
select * from tab1