Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Qualify and group
- 4 Answers
- 17032 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 |
How do you see a ddl for an existing table?
Highlight a few of the important components of Teradata?
What is stored procedure in teradata?
what is the query for retrieve the unique values(not display the duplicates values) from single table?
Explain the types of join supports by teradata?
What are the commands to make a new table, change a table and remove a table in teradata?
What are default access rights in teradata? What explicit right can be given to a user?
How to view every column and the columns contained in indexes in teradata?
Describe primary index in teradata?
What is the difference between correlated sub queries and inner queries?
What is meant by a Least Cost Plan?
i have column like below studentid studentname sub1 sub2 sub3 1 aaa 40 70 90 2 bbb 60 80 50 i want to execute every student highest mark in which subject my o/p like below studentid studentname sub3 sub2 1 aaa 90 2 bbb 80
Teradata 
