hello
how do i change values into columns with out all the the blanks ..
i have orderunits table(orderid number,value and name are varchar2).
i tried case stmts and not getting results like below,meaning i get rows multiplied,for example in here i get total 25 rows but i should get total 15 or so
Code:"CASE WHEN fNAME='Units' then p.value else null END AS unit_name,"
Code:Order_ID UNIT_NAME DATE_NAME 30766600 1 30766600 090909 30766600 1 30766600 090909
any help is much appreciated
thank you
Code:ORDER_ID VALUE NAME 30766600 090909 Date 30766600 090909 Date 30766600 090909 Date 30766600 090709 Date 30766600 090709 Date 30766600 090609 Date 30766600 090609 Date 30766600 090509 Date 30766600 090509 Date 30766600 090509 Date 30766600 090409 Date 30766600 090409 Date 30766600 090309 Date 30766600 1 Units 30766600 1 Units 30766600 1 Units 30766600 1 Units 30766600 1 Units 30766600 13 Units 30766600 1 Units 30766600 2 Units 30766600 1 Units 30766600 3 Units 30766600 1 Units 30766600 1 Units orderid date units 30766600 090909 1 30766600 090909 1 30766600 090909 1 30766600 090709 1 30766600 090709 1 30766600 090609 13 30766600 090609 1 30766600 090509 2 30766600 090509 1 30766600 090509 3 30766600 090409 1 30766600 090409 1 30766600 090309 30766600 090409 30766600 090409 30766600 090309 30766600 090409
Reply With Quote