create table t (
acct_no varchar2(3), code varchar2(3), meaning varchar2(3), seq_no number
); we can have multiple acct_no is given table. for given acct_no = 123 code is stored in specific sequence which is there in seq_no. according to that seq no i need to display in one row only. eg: "ABC" has seq_no= 1 then it should be 1 st displayed. if "KJH" has seq_no = 2 it should be displayed next after "ABC". if you any idea how we can do this

create table t (
  acct_no varchar2(3), code varchar2(3), meaning varchar2(3)
);

insert into t values ('123','ABC','abc');
insert into t values ('123','BVC','bvc');
insert into t values ('123','DDD','ddd');

insert into t values ('456','JKL','abc');
insert into t values ('456','MNO','bvc');

select * from (
  select t.*, 
         row_number() over (partition by acct_no order by code) rn 
  from t
)
pivot (
  max(code) as cd, max(meaning) as mn
  for (rn) in (1 as one, 2 as two, 3 as three)
);

ACC ONE ONE TWO TWO THR THR
--- --- --- --- --- --- ---
123 ABC abc BVC bvc DDD ddd
456 JKL abc MNO bvc

Chris- In the latest follow up from the OP he added a seq_no column to the table and it seems he wants to sort on that accordingly. So i'm thinking we just need to put 'order by' at the end of your query.


create table t (
acct_no varchar2(3), code varchar2(3), meaning varchar2(3),seq_no number
);

insert into t values ('123','ABC','abc',4);
insert into t values ('123','BVC','bvc',4);
insert into t values ('123','DDD','ddd',4);

insert into t values ('456','JKL','abc',2);
insert into t values ('456','MNO','bvc',2);

select * from (
select t.*,
row_number() over (partition by acct_no order by code) rn
from t
)
pivot (
max(code) as cd, max(meaning) as mn
for (rn) in (1 as one, 2 as two, 3 as three)
)
order by seq_no;

ACCT_NO SEQ_NO ONE ONE TWO TWO THR THR
456 2 JKL abc MNO bvc - -
123 4 ABC abc BVC bvc DDD ddd

row_number() over (partition by acct_no order by code) rn 

row_number() over (partition by acct_no order by seq_no) rn