![]() |
Hi Team,
22 Oct 2014
| 1 comment
,
|
![]() |
/*
18 Jun 2014
| 2 comments
,
|
![]() |
Hello All,
05 Jun 2014
| 4 comments
,
|
![]() |
I am working on desiging a summary table and need to determine the grouping columns. I was looking at DBQLObjTbl TypeofUse, but it doesn't show a group by use. Is there another way to determine the group by columns without having to parse through the sql?
12 Mar 2014
,
|
![]() |
Hi,
02 Feb 2014
| 8 comments
,
|
![]() |
Hi,
I am new to Teradata and I am working on query for which I greatly appreciate any help.
i have data in a table as shown below:
date id value 1-Jan-13 1 100 2-Jan-13 1 100 3-Jan-13
07 Jan 2014
| 1 comment
,
|
![]() |
Can someone throw some light how can QUALIFY,GROUP BY and HAVING be used together?
04 Jul 2013
,
|
![]() |
I have data as follows in a Table ( 3 columns ):
24 May 2013
| 5 comments
,
|
![]() |
Hello, I have an issue regarding a group by for my query: Error 3540 I understand what it means on a basic level and I believe the issue revolves around this particular column CAST((COALESCE(price, 0.000000)) AS DECIMAL(18,6)) * quantity amount
14 Jul 2011
| 1 comment
,
|
![]() |
We stumbled upon this by accident. We have a query that runs much faster when a group by is added to a derived table when one of the columns in the derived table is the result of a cast/concatenation operation. The first query/explain posted below has the group by in the derived table. It shows the cast/concatenation being resolved when the derived table is materialized in step 2 in the EXPLAIN. Result is 761 rows and I assume 761 resolutions of the cast/concatenation. The group by does not eliminate any dups.
03 May 2011
| 3 comments
,
|