Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Qualify and group
- 4 Answers
- 16887 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 differences between Fastload and Multiload as per DBA aspect ?
What interface is used to connect to windows based applications?
Difference between client character set and server character set? What is the use of these two?default character set in teradata?
how do you manage the production space. what are the proactive methods you can take ?
What are the joins in teradata?
How do you create a table with an existing structure of another table with data and with no data?
How do you do backup and recovery in teradata?
What can be achieved by using the teradata rdbms?
What is a sparse index?
How many sessions of MAX is PE capable of handling at a particular time?
What are different table types used in teradata?
What is the default join strategy in Teradata???
Teradata 
