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

Name three sql operations that perform a sort.

960

What are the benefits of pl sql?

1057

What is left join in sql?

1006

Why do we use set serveroutput on?

927

What is sql injection vulnerability?

872

What is rename in sql?

921

How much does sqlite cost?

989

How do I use google cloud in sql?

1036

What is sequence in sql?

948

What is a sql profiler?

965

What is the meaning of disabling a trigger?

1117

Does a user_objects view have an entry for a trigger?

965

what is the command used to fetch first 5 characters of the string? : Sql dba

1588

What is a primary key? Explain

922

What is duration in sql profiler trace?

1022