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.
- 4 Answers
- 11380 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
Is drop table faster than truncate?
what's the difference between a primary key and a unique key? : Sql dba
What is dml with example?
what are date and time intervals? : Sql dba
What is sql query optimization?
Is sql an operating system?
Can we insert in sql function?
What is set transaction?
What are reports usually used for?
How many columns should be in an index?
How do you select unique values in sql?
describe mysql connection using mysql binary. : Sql dba
What is foreign key sql?
What is pivot in sql?
how would you enter characters as hex numbers? : Sql dba
