Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Qualify and group
- 4 Answers
- 17169 Views
- CTS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / charan
Group By will useful for Grouping the Values from file or table and
Qualify Will Useful for Filters the data from file or table
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / tdguy
group by is a aggregate function whereas the qualify
function is generally used for olap purposes along with
rank function.
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / 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 |
What are default access rights in teradata?
Can any one plz provide the teradata interview questions?
What is SQL Assistence?please eample
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
What is primary index and secondary index?
Why FLOAD does not support multiset tables??
What is the diffrence between Multiload & Fastload interms of Performance?
Can we collect statistics on multiple columns?
What are the updated features of teradata?
If a Node is busy what are the steps you can take to avoid ?
What do you mean by teradata intellicloud?
What are the components provided on node?
Teradata 
