Difference between Qualify and group

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How is the teradata different from oracle?

623


Explain the term 'row' related to relational database management system?

530


What is spool space? Why do you get spool space errors?

510


What is teradata and why it is used?

581


What is the function of parser component in teradata?

619






What is the syntax for case when statement?

585


How to view every column and the columns contained in indexes in teradata?

582


Explain teradata utilities?

563


If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?

1893


During the Display time, how is the sequence generated by Teradata?

613


Difference between inner join and outer join?

582


Highlight all the modes that are present under Confidence Level.

537


Explain and compare pros and cons of snow flake schemas?

609


What are the design features involved in teradata?

543


What is the use of virtual processor connectivity in teradata?

565