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
how to run 'mysql' commands from a batch file? : Sql dba
Is sql microsoft?
what are the differences among rownum, rank and dense_rank? : Sql dba
What does 0 mean in sql?
Which join condition can be specified using on clause?
what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba
What is implicit cursor in pl sql?
What are the parts of a basic sql query?
How can we find duplicate records in a table?
how to use myisamchk to check or repair myisam tables? : Sql dba
what is the difference between rownum pseudo column and row_number() function? : Sql dba
What is difference between procedure and trigger?
Why should I use postgresql?
Explain the uses of control file.
What is record in pl sql?