SELECT
    t1.referenceno, t2.credit, t3.debit
FROM
    (SELECT
         referenceno, credit, debit, employeeidno
     FROM
         earningsamendment
     WHERE
         employeeidno = 'D0080000010') AS t1
LEFT JOIN
    (SELECT
         referenceno, credit, debit, employeeidno
     FROM
         earningsamendment
     WHERE
         employeeidno = 'D0080000010') AS t2 ON t2.referenceno = t1.referenceno
LEFT JOIN
    (SELECT
         referenceno, credit, debit, employeeidno
     FROM
         earningsamendment
     WHERE
         employeeidno = 'D0080000010') AS t3 ON t3.referenceno = t1.referenceno
WHERE
    t2.referenceno = t1.referenceno
    AND t3.referenceno = t1.referenceno
ORDER BY
    t1.referenceno

select referenceno, max(credit) as Credit, max(debit) as Debit , employeeidno
   from earningsamendment group by referenceno, employeeidno

; with cte as (
   select referenceno, max(credit) as Credit, max(debit) as Debit , employeeidno
   from earningsamendment group by referenceno, employeeidno
   )
   select * from cte where Credit>0 and Debit>0

(SELECT credit from earningsamendment e3
     where e3.employeeidno = e2.employeeidno and
           e3.referenceno = e2.referenceno and
           isnull(e3.credit ,0) <> 0  ) as credit,


  (SELECT debit from earningsamendment e3
     where e3.employeeidno = e2.employeeidno and
           e3.referenceno = e2.referenceno and
           isnull(e3.debit ,0) <> 0  ) as debit
  FROM earningsamendment e2
  GROUP BY referenceno,employeeidno