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
How is the teradata different from oracle?
Explain the term 'row' related to relational database management system?
What is spool space? Why do you get spool space errors?
What is teradata and why it is used?
What is the function of parser component in teradata?
What is the syntax for case when statement?
How to view every column and the columns contained in indexes in teradata?
Explain teradata utilities?
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 ?
During the Display time, how is the sequence generated by Teradata?
Difference between inner join and outer join?
Highlight all the modes that are present under Confidence Level.
Explain and compare pros and cons of snow flake schemas?
What are the design features involved in teradata?
What is the use of virtual processor connectivity in teradata?