Mark Tabor

Mark Tabor

  • 932
  • 1.7k
  • 343.9k

After adding column in select and group by i am getting extra rows

Mar 16 2022 12:22 PM

select distinct 'carTypes' as type, mi.WOMENNAME as "mother name", mi.womencnic as "mother CNIC", '' as BFORMNO, '' as child_gender, mi.PROVINCE, mi.district, mi.tehsil, mi.HUSBANDNAME, mi.PHONENO contact, mi.address, SUM(p.amount) paid_amount

from MINFORMATION mi

inner join PAYMENTINFORMATION p on p.BENEFICIARYID=mi.WOMENID and p.BANKSTATUS='Successfull'

where mi.month IS NOT NULL


and p.generationdate between '24-JUN-21' and '01-JAN-22'

group by  mi.WOMENNAME, mi.womencnic,mi.PROVINCE, mi.district, mi.tehsil, mi.HUSBANDNAME, mi.PHONENO , mi.address

this is my query I need generationDate in select list as well which is coming from PAYMENTINFORMATION  tableso after adding it in select list it ask me to add it in group by as well by doing so I am getting extra row  my actual rows are 1629 but after adding generationDate in select and order by I am getting 1944 Rows how to solve it its oracle query


Answers (2)