User Profile

Collapse

Profile Sidebar

Collapse
maggo119
maggo119
Last Activity: Oct 19 '11, 07:31 AM
Joined: Aug 16 '11
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • maggo119
    replied to DB2 SQL select
    in DB2
    Thanks for your reply, I already solved by using 'Case When' statements.
    See more | Go to post

      Leave a comment:

    • maggo119
      started a topic DB2 SQL select
      in DB2

      DB2 SQL select

      Hi I have a table which looks like this:

      Nr Name1 Name2
      == ===== =====
      1--John---------
      1----------Smith
      2--Ricky--------
      2----------Fred
      2----------Mason
      3--Steve--------


      The result shoudl look like this:

      Nr Name1 Name2 Name3
      == ===== ===== =====
      1 John Smith
      2 Ricky Fred Mason
      3 Steve

      I already tried...
      See more | Go to post
      No activity results to display
      Show More
      Working...