Labels

2017 absence absence management Account accounting Agents AIM aliases AME and APEX API application application utilities lookups approval assignments ATO Australia Bank bi publisher budget business business groups Business Objects CAGR candidates cartisian product case CEMLI Center Stage channels Classification Cloud competency concurrent Configuration configuration profile constants contextualization conversion correction cost costing count coverage area customization data database date DateTracked deductions define design develop DFF diagnostics distinct document earnings ebs EIT Element employee enhancements erp excel expression extension failure Fastformula FBT Flexfield FND fndload foreign key forms Formula fringe benefit FRM-40654 from FTE Functions fund fusion GenAI GL global transfer grade help hierarchy HR HRMS human resource management system implementation income information interfaces internet interview job join key flexfield KFF KPI language learning leave legal employer legislation links listagg lists localization location management New Year OAIAS obia obiee OLF onboarding oracle Oracle ACE Oracle AI Agent Studio oracle applications oracle descriptive flex field oracle descriptive flexfield oracle ebs oracle erp oracle fusion HCM Oracle HCM oracle hrms oracle hrms interview questions oracle hrms modules oracle hrms modules list oracle hrms organization oracle hrms table oracle hrms tables oracle hrms tutorial oracle irecruitment oracle legal entities oracle lookups oracle organization hierarchy oracle payroll oracle payroll interview questions oracle payroll tables oracle self service order by Organization organization type otbi package package body package specification patch payg Payment payroll people group perform person personalisation phase pl/sql position Power BI primary key process profile programs project Python qualifier Query question questions Recruiting Center Recruitment regex regular expression reporting tool reports requests requirement requisition resume retropay RICE salary schema security profile select SIT smartorg sql statutory stores STP Super Superannuation system systems Table Taleo taleo 15B Taleo Recruitment tax termination test testing trunc update user group user management user type value set variables View Views Web ADI webadi where work relationship

Monday, 2 March 2026

SQL Series | Using Aggregate Functions - Part I

 Hello Again,

Can’t believe we are already in March! There is a lot happening globally at all levels – geo-politics, technology, you name it, it feels like everything is on steroid mode 🤔 But today I would like to take a step back and focus some of the basic functions in SQL (yeah, you read it right)

We’ll try to look at three ‘Aggregate functions’ from Oracle EBS schema perspective. As the name indicates - Aggregate functions take multiple input rows and return a single summary value per group (or per entire result set).

So, let's get start (the third one is my favorite)

Click here to Read More »
No comments:
Labels: , , , , , ,
Subscribe to: Comments (Atom)