0 - 5 of 5 tags for qualify

/*
Hi,  I am trying to run the below query, in vain. I was able to get the results by using a different logic.
However I am not able to understand why my query for search didn’t work, while my query for sales worked (they are both essentially the same query with different column names)
*/

Can someone throw some light how can QUALIFY,GROUP BY and HAVING be used together?
Any link to docs or simple example will be usefull.
Also which one takes precedence, when used together and what is the correct syntax when using all three of them?
 
 

Hi!

I am a beginner concerning the Teradata. I was trying to find simple descriptions on the internet about functions QUALIFY; RANK; OVER; PARTITION BY - unfortunately unsuccessfully. I coudn't find a simple explanation what does each of the funcions do.

Can anyone send me a link or give a explanation about this functions.

I have a requirement in that i have to use two qualify in the same query based on the value returned(this value is also returned by a qualify statement).

 

Ex :

 Ex1

 

NAME1

NAME2

AGE

RANK

A

B

1

1

A

C

Hi,
I am working on Teradata to Oracle migration project.

Select frm_crncycd,to_crncycd,exch_rate from exchange_rate
group by 1,2
qualify(rank(frm_dt)) =1

Can someone explain what is the behavior of above query.
So that i can rewrite the query in Oracle.