SQL query doubt

[ngindia]

I have to display a data like

A 1
2
3


but where as i m getting the data like

A 1
A 2
A 3

can any one help me ASAP

[marist89]

More info. What's your table structure? Some example data?

[ngindia]

there are 15 fields out of which 6 fields are repeating
i want them to appear once only
and all the records are unique

[marist89]

Thanks for the example data and table structure.

I am only guessing at what you want, but here goes anyway...

SQL> select * from xyz
  2  order by x;

         X          Y          Z
---------- ---------- ----------
         0          3          3
         0          2          6
         0          1          9
         1          1          1
         1          0          4
         1          2         10
         1          3          7
         2          2          2
         2          0          8
         2          1          5

10 rows selected.

SQL> break on x
SQL> /

         X          Y          Z
---------- ---------- ----------
         0          3          3
                    2          6
                    1          9
         1          1          1
                    0          4
                    2         10
                    3          7
         2          2          2
                    0          8
                    1          5

10 rows selected.

[ngindia]

i m little in database side can u tell me what is this break
can u give me full query