Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I have table like below.
i want to restrict the table to show only Max(line_no) on each unique loaded file. i want output as below. Please help me how we can fix.
Not sure if you are looking for something like this:
LOAD Loaded_File
Max(Line_No) as Max Line_No
Resident sourceTable
Group By Loaded_File
HTH
Best,
Sunny
try sunindia advice,hopes it works.