Teradata Query-URGENT

Database
Enthusiast

Teradata Query-URGENT

There is table with coulmns:

INTL_EMP_ID

PRSCT_FILL_ID

ACTVTY_TS

EMPLYE_NBR

EMP_ID

Problem Statement: select INTL_EMP_ID from table for that PRSCT_FILL_ID.

order by ACTVTY_TS in ascending order and get the first EMPLYE_NBR and its corresponding EMP_ID.

Thank you.

2 REPLIES
Senior Apprentice

Re: Teradata Query-URGENT

Whenever I read URGENT I tend to fall into tranquilo, mañana mode :-)

QUALIFY ROW_NUMBER() OVER (PATTITION whatever ORDER BY whatever) = 1

Junior Supporter

Re: Teradata Query-URGENT

Hi Dieter.

I'm afraid the mode I fall into is much less polite than yours... ;-)

Cheers.

Carlos.