First Sorted Value

qv_jagan — Fri, 14 Dec 2012 14:33:49 GMT

I have a table like one shown below

I want to find first Row of T2 for each T1 as shown below. Please help.

I tried using first sorted value but I was not able to write.

could someone please help me.

Thanks in advance.

Re: First Sorted Value

CELAMBARASAN — Fri, 14 Dec 2012 18:22:13 GMT

Hi,

Check with the FirstValue and LastValue functionality to get first and last values.

Load

T1,

FirstValue(T3) AS T3,

FirstValue(T2) AS T2

Resident TableName

Group By T1;

Hope it helps