Difference between Qualify and group

Answer Posted / ramreddy

Group by is like partition by in OLAP
like tradition group by following having class if we filter (aggregate columns )
Qualify is also functioning like having in OLAP.with partition by class .

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you mean by fastexport in teradata?

555


What is the meaning of Caching in Teradata?

689


What is TPD?

902


What is teradata? Also, list out some of the primary characteristics of teradata.

577


What do high confidence, low confidence and no confidence mean in explain plan?

587






Give a justifiable reason why Multi-load supports NUSI instead of USI.

672


What is the syntax for case when statement?

585


What are the functions of a Parser?

606


What is teradata?

644


Can we collect statistics on multiple columns?

563


What are the different functions included in the server software?

600


Explain teradata utilities?

563


Explain the term 'tables' related to relational database management system?

590


What does sleep function does in fast load?

616


What are default access rights in teradata?

621