
Not applicable
2012-04-02
11:12 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
What is the function of DISTINCT and NODISTINCT in AGGR function?
What is the function of DISTINCT and NODISTINCT in AGGR function?
May be someone can explain to me.
Thanks,
Danny H.
4,353 Views
1 Reply

Not applicable
2012-04-03
02:12 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Danny,
by default aggregation function is Distinct that is when you code
something like this =aggr(SUM(SALARY) ,Empid ) it means the aggrgation of salary is
done only on distinct records if you want to do it on repeted records like Empid 1001,1002 repaeting more than once
and if you need to take this into account then you have to use a keyword NONDISTINCT
something like this =aagr(NODISTINCT SUM(SALARY),Empid)
then it will sum salary for repeted EmpId
Hope you got the point
Warm regards,
Anant Dubey
