1 Reply Latest reply: Jul 10, 2013 9:05 AM by riedelme RSS

    Query Help.

    Rajnish Chauhan

      Hi,

         i have records in table like below.

       

         Empid     salary      

         101         1000          

         102         2000

         101          500

         103          100

         102          700

         102          600

       

         i want out put like below. pls. help.

         Group by should be on Emp id

       

         empid         salary

         101             1000

          null               500

          102             2000           

          null               700

           null               600

          103              100

        • 1. Re: Query Help.
          riedelme

          This forum is for SQL*Developer issues - questions about working with Oracle's SQL*Developer product.  Your question is a SQL issue and should be asked in the SQL and PL/SQL forum in the Oracle Database category.  Please close this tread and ask your question there.