Difference between Qualify and group
- 4 Answers
- 15007 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 is the diffrence between Multiload & Fastload interms of Performance?
Fast Load Script is failed and error tables are available then how do you restart?
What is the purpose of upsert command?
What is meant by a Parsing Engine?
What's the syntax of sub string?
How to cast date "2015-03-03-012204-000000" to timestamp
What are the functions of a teradata dba?
How do you load Multiple files to a table by using fastload scripts?
in teradata level primary in table level allows duplicates why?
what is object level locking ? where do appear this type of locking ?
What is upsert statement in teradata?
What is the difference between correlated sub queries and inner queries?
Teradata 
