select * from tab group by acc

I have a tablle like this.
cust acc
---------------
a 1
b 2|3
c 4|5|6

I Want below o/p:
cust acc
-----------
a 1
b 2
b 3
c 4
c 5
c 6
Please any one can you have any ideas share me.
I have urgent requirement.

Question Posted / monu singh shekhawat

4 Answers
12420 Views
Cap Gemini, MTS, I also Faced
E-Mail Answers

Answer Posted / monu singh shekhawat

select * from tab
group by acc

Is This Answer Correct ?

1 Yes

7 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Is it mandatory for the primary key to be given a value when a new record is inserted?

1198

What is out parameter used for eventhough return statement can also be used in pl/sql?

1077

What is the primary use of normalization?

1004

What is sql trigger example?

1067

What is sql catalog?

1022

what is a composite primary key ? : Sql dba

1052

What is sql and how does it work?

1175

what is a tablespace? : Sql dba

1051

What is the least restrictive isolation level? : Transact sql

1069

what is the use of set statement in tsql? : Transact sql

1011

what are the non-standard sql commands supported by 'mysql'? : Sql dba

1120

Is left join inner or outer?

1014

Does sql view stored data?

959

What is an emotional trigger?

1005

Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?

1038