Hi All,
 
Is there any way to count queries which do all row scan of tables? I tried to get the same through dbc.DBQLExplainTbl but it didnt help.
Any help would be appreciated.
 
Thanks,
Dinesh

Hi guys,
I'm relativley new to this so please bare with me.  I'm trying to count the number of days a filed has a value under 200. Between two dates.  i.e.
 
For accounts in the last 180 days,

I have the following CASE WHEN statement in my query and would like to get a count of each "category", so output would look something like this:
 

I am pretty new to teradata and know some basic SQL but I find that I am struggling with this problem.
 

Hello,

Hi,

Need help on the following scenario.

Consider the following dataset

transaction created_date closed_date

1                1-jan-2011       5-jan-2011

2                2-jan-2011       10-jan-2011

3                5-jan-2011       5-feb-2011

4                10-jan-2011     6-mar-2011

Hi,

I am having two tables each having 20 columns. I want to compare these two tables table1 and table2 to get the count of all the records in table1 and all therecord in table2 and the differnece of records in a single query. Is it possible in Teradata 12??

Hi,

I am facing a weird problem of which can not really figure out what could be the reason of that. Consider following SELECT statement:

SELECT
Col1, Col2, Col3
FROM
View1
QUALIFY ROW_NUMBER() OVER(PARTITION BY Col4 ORDER BY Col5) = 1

We get 644,539 rows in return.

If we take a COUNT(*) as below:

SELECT COUNT(*) FROM
(
SELECT
Col1, Col2, Col3
FROM
View1
QUALIFY ROW_NUMBER() OVER(PARTITION BY Col4 ORDER BY Col5) = 1
) A

It gives us count to be 158,446

If we do SELECT * as below:

SELECT * FROM
(
SELECT
Col1, Col2, Col3
FROM
View1