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.
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
What is the usage of nvl function?
What is sql keyword?
What do you think about pl/sql?
what is the functionality of the function htmlentities? : Sql dba
How to run sql functions in pl/sql?
What is a composite primary key?
How to use distinct and count in sql query? Explain
What is sql select statement?
Is nosql relational?
What is rename in sql?
What is the difference between the conventional and direct path loader? : aql loader
Is sql the best database?
What is an intersect?
What will you get by the cursor attribute sql%rowcount?
What are analytic functions in sql?