select decode(cust,'a',acc) as A ,decode(cust,'b',acc)

. have a tablle like this: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 I Want below o/p: cust acc --------------- a 1 b 2|3 c 4|5|6 Please any one can you have any ideas share me. I have urgent requirement.
CUST ACC
a dv
b fg
b bh
c mk
c cl
c so
result:-
A B c
dv fg mk
bh cl
so

Question Posted / barun

3 Answers
6488 Views
I also Faced
E-Mail Answers

Answer Posted / barun

select decode(cust,'a',acc) as A ,decode(cust,'b',acc) as B,decode(cust,'c',acc) AS C from customer

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is orm in sql?

1099

what is cross join? : Sql dba

1054

What are the three forms of normalization?

1096

How to process query result in pl/sql?

1204

What is basic structure of pl sql?

1133

How to start the command-line sql*plus?

1112

What does pl sql stand for?

1158

what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure

2173

What can I use instead of union in sql?

1024

how to drop an existing view in mysql? : Sql dba

1108

What are the types of records?

1040

What is the maximum number of rows in sql table?

1083

what is a cursor? : Sql dba

1066

How many developers work on postgresql?

1042

What is sql in oracle?

1111