Difference between Qualify and group

Answer Posted / nitin bansal

Group by is used to find an aggregate like SUM or count for
a group of values. Where as Qualify is used like the having
clause on functions like RANK.

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is bteq utility in teradata?

567


What are the uses of bynets in multi-node systems?

584


Explain vproc in teradata?

562


Can we collect statistics on table level?

598


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

546






How teradata makes sure that there are no duplicate rows being inserted when its a set table?

555


What is upsert statement in teradata?

609


Explain teradata architecture?

632


How do you do backup and recovery in teradata?

545


Explain the most common data types used in teradata?

586


What do you mean by tpt in teradata?

587


How many sessions of MAX is PE capable of handling at a particular time?

587


What are the different design perspectives used in teradata?

546


How do you determine the number of sessions?

610


What are the various etl tools in the market?

581