Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I want to get the ENAME,SAL,COMM,DEPTNO,GETDATE for each depatarment where latest date of GETDATE.
How to achieve this?
For example
EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO LASTDATE GETDATE
84 ENAME84 CLERK 5 20101217 800 500 30 20150316 2015/10/28
Hi,
Find below example from Help Menu
Load Customer,
firstsortedvalue(PurchasedArticle, OrderDate) as
FirstProductBought from abc.csv
group by Customer;
Note:
FirstSortedValue() is aggregated function so you have to use Group by clause and add all the which you dont required to aggregate
Regards
Try function FirstSortedValue()
How to achieve the same? Could you provide in a sample file?
Hi,
Find below example from Help Menu
Load Customer,
firstsortedvalue(PurchasedArticle, OrderDate) as
FirstProductBought from abc.csv
group by Customer;
Note:
FirstSortedValue() is aggregated function so you have to use Group by clause and add all the which you dont required to aggregate
Regards