Oracle Reports Builder
Hi, i have one query plz help me on the same....
I am creating the report in oracle report builder 6i, i made every thing but i stuck on one problem. it is i used group by command in sql query. i got the total of one column. but in that column there are no. of same customer name in a month which i want only one name or customer and total for this month of invoice amount. and total invoices in this month just figure suppose 2 or 5, 100 anything related with this customer.
Plz send me the proper solution on it as earliest.
Thanks
Swapnil
Software/Hardware used:
oracle
Software/Hardware used:
oracle
ASKED:
July 24, 2010 11:11 AM
UPDATED:
January 17, 2011 5:06 PM
Answer Wiki:
I understand what you are saying. You are gettign multiple identical records returned from your query. A way to get around this prblem is : Lets say your Query is as follows:
SELECT ...... group by .....
What you coudl do is to do it like this:
Select ...... from (your original query)
group by......
This will eliminate the duplicate records.
To see all answers submitted to the Answer Wiki: View Answer History.
Ss6601, your question is not clear enough.
If you are asking for help on modifying your SQL query, please post your current query.
Also, it would be easier to understand if you post some example data, and the results you would want to get from such data.
You might just need to incude an additional column in your GROUP BY clause, but we really need to see your query, and understand your requirement first.
why not just delete the duplicate entries?
You cannot just ‘delete the duplicate entries’. This is not related to an excel sheet or similar.