Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a table :
Date | Call No | status
i want to load the min(date) of a perticular call no where status is 79 or 13...
Can any one help me to write the code for this
i tried this but it is not working
LOAD
min(Date) as MDate,
Call_no,
Status
FROM (ooxml, embedded labels, table is Day1) where status=79 or status=13;
thnks a lot... code worked