. 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
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
What are the types of subqueries?
Can we use distinct and group by together?
which types of join is used in sql widely? : Sql dba
What is scope of pl sql developer in future?
What is the use of triggers?
What is the current version of sql?
What is structural independence and why is it important?
Is and as keyword in pl sql?
What are all the ddl commands?
What is clause in sql?
What is the difference between sql and isql*plus?
What is an inner join sql?
Is sql difficult?
Can ddl statements be used in pl/sql?
What is autocommit sql?