Answer Posted / 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 |
Post New Answer View All Answers
Why does varchar occupy 2 extra bytes?
What type of indexing mechanism do we need to use for a typical data warehouse?
What are the commands to make a new table, change a table and remove a table in teradata?
What is oltp?
What are the different softwares used with their functions in teradata?
What is the difference between fastload and multiload? Which one is faster?
Is multi insert ansi standard?
There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?
any one answer me how they can analyzing the project using data ware housing?
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
Give the sizes of SMALLINT, BYTEINT and INTEGER.
What are the various indexes in teradata?
Why managing the data is important?
In Teradata, what is the significance of UPSERT command?
What is upsert statement in teradata?