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
12616 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

What is dynamic sql in pl sql?

1090

What is the difference between a procedure and a function?

1214

How to handle bulk data?

1367

What is implicit cursor in pl sql?

1148

Can we use ddl statements in stored procedure?

1192

What are commit, rollback, and savepoint?

1048

What is crud diagram?

993

Can unique keys be null?

949

What is the use of function in sql?

1152

What is recursive join in sql?

1069

How many developers work on postgresql?

1042

How do I start sql from command line?

1081

What is the function that is used to transfer a pl/sql table log to a database table?

1068

Is sql an operating system?

1075

What is a record in pl/sql?

1216