Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Qualify and group
- 4 Answers
- 16823 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 the steps to create a data model?
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
what are the uses of fact table and dimension table in banking project?
Why AMP & PE are called Vprocs?
What are some commonly used bteq scripts?
Difference between star and snowflake schemas?
What is meant by MATCHTAG in multiload utility?
Explain and compare pros and cons of start schemas?
What do you mean by parsing?
What is partitioned primary index (ppi)?
Can you connect multiload from ab initio?
Highlight the points of differences between the database and user in Teradata.
Teradata 
