1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

How to club rows and its values in a table

Discussion in 'SQL PL/SQL' started by 32837708, Jul 18, 2013.

  1. 32837708

    32837708 Guest

    Hi Frnds,
    Am new to oracle ...trying to get query for clubbing rows and its values in a table. Can anyone help me out .
    Current Table:

    Apps A B
    BDMS 15 148
    BDMS-DSL 2 35
    BDMS-Einstall 0 0
    BDMS-FTTP 14 103

    Expected Table:

    Apps A B
    BDMS 31 551
  2. zargon

    zargon Community Moderator Forum Guru

    Likes Received:
    Trophy Points:
    Aurora, CO
    I do not see where the 551 is coming from since the sum of column b is 286.

    This is a basic sum()/group by query; you will also need to use the substr() function to return the same string from all columns.

    I won't provide the query as that should be your task to complete.

    David Fitzjarrell