not at work, so can't test this but put each col in a max(function) like: max(id), max(case when field_name = 'text1' then field_value else null end)column1,
etc ... Mike On Thu, Dec 30, 2010 at 12:35 PM, gayathri Dev <gd0...@gmail.com> wrote: > how to remove the multiple rows generated by Case statements? > > For eg: > > Table : tab > case_num, ID, Field_name, Field_value > 6, 1, TEXT1 , string1 > 6, 1, TEXT2 , string2 > 6, 1, TEXT3 , string3 > > select distinct > id, > case when field_name = 'TEXT1' then field_value end column1, > case when field_name = 'TEXT2' then field_value end column3, > case when field_name = 'TEXT3' then field_value end column3, > from tab where case_num = 6; > > Output: (that i am getting) > ID, column1, column2, column3 > 1, (null), string2, (null) > 1, string1, (null), (null) > 1, (null), (null), string3 > > *Expected Output: > ID, column1, column2, column3 > 1, string1, string2, string3* > > I want to suppress those row generated for else part of case statement, > Please let me know how do we do that? > > Thanks and happy holidays > ~G > > -- > You received this message because you are subscribed to the Google > Groups "Oracle PL/SQL" group. > To post to this group, send email to Oracle-PLSQL@googlegroups.com > To unsubscribe from this group, send email to > oracle-plsql-unsubscr...@googlegroups.com > For more options, visit this group at > http://groups.google.com/group/Oracle-PLSQL?hl=en -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
