1. Cast ( exception_event _ts date ) = date -1
2. Exception_event _ts between timestamp '06/05/2009 00:00:00' and timestamp '06/06/2009 00:00:00'
iceman23
Last Activity: Oct 13 '09, 03:29 PM
Joined: Aug 26 '09
Location:
-
Compute Time Difference in Teradata
Hello,
My question in teradata would be, will it be possible to get the time difference of 2 given date/time, given that the first value of the would be the 1st row of 2nd column then the second value would be the 2nd row of 1st column.
You may check the attachment.
Thanks in advance.... -
The requirement is that if a match for a certain word/s is within the group of data just like the example above, the result should return 'NULL' or should not return any value at all in the output.
somewhat, I need to determine if a word/s is included in the group and eventually filter that set of PK's and not be included in my result/output once the query is done executing.Leave a comment:
-
no buddy i don't hv any idea about teradata -
Hello,
Are you familiar with teradata sql? -
Filters in Teradata
Hello,
Given the data below, how will I be able to filter or create a condition/s, given that the PK's are 103895800 and 41775190, what I would like is that if in this group of data ; 'Item Pkg' will be anywhere in the group then the result will have to be NULL.
103895800 41775190 9/15/2009 7:03 8/28/2009 Item Pkg User1
103895800 41775190 9/15/2009 7:04 8/28/2009 Item Pkg User1
103895800... -
The error I got was No more Spool space for <USER>Leave a comment:
-
Hello Amit,
I already posted my query, will you be ale to check that out?
Thanks! -
To be able to avoid getting an error of out of spool space error what is the best thing for me to do?Leave a comment:
-
Joining 2 Queries in Teradata
Hello,
SCENARIO:
I would like to have these 2 queries be combined and the results as well. I tried to add QUERY2 in the WHERE clause of QUERY1, what I got was multiple field instances as a result. Included below the the query/result that I would wnt to achieve.
Thanks in advance!
QUERY 1
LOCKING ROW FOR ACCESS
...Code:SELECT DISTINCT HIST_1.ORDER_ID AS ORDER_ID,
-
How to reduce and avoid spool space error in Teradata
Hello,
How will I be able to reduce the Spool of my query below:
LOCKING ROW FOR ACCESS
SELECT
VCCN863.ORDER_I D AS ORDER_ID,
VCCN863.EVENT_O RIGINATOR_NM AS ATTUID,
VCCN863.BAN AS BAN,
VCCN863.EXCEPTI ON_EVENT_TS AS BEGIN_TIME
FROM TELCO_UNREG_RET AIL_VIEWS.VCCN8 63_EXCEPTION_EV ENT_HIST VCCN863
INNER JOIN TELCO_UNREG_RET AIL_VIEWS.VCCN8 63_EXCEPTION_EV ENT_HIST... -
Hello Amit,
I had this error 3706: Syntax error: expected something between '(' and the 'SELECT' keyword.
Where can I send you my query for you to be able to check and at the same time give suggestion on how to resolve my error.
Thanks! -
thanks amit! I wasn't able to test the query you've provided yet. Thanks again for the time and help! -
Hello amitpatel66,
I wasn't able to get back to you on my question last time. We have to disregard my first question.hehehe . I have though a new question posted under ORACLE with the subject Count in Teradata. Will you be able to have a quick look on that, and share your thoughts with regards to my question? thanks! -
Count in teradata
Hello,
Will you be able to help me in achieving my expected outcome?
Table 1 shows sampler items and the corresponding names, what I would like to achieve is that, i'll be able to count the number of sampler items regardless of the corresponding names (see expected outcome table).
**Note just disregard the single quotes (use for spacing purposes)
Table
sampler '... -
TERADATA Equivalent of ROWCOUNT
Hello,
I would want to add a column or a row count in my query.
I already used RANK and CSUM, but unfortunately these doesn't work when you are using GROUP BY.
Any suggestions?
Thanks in advance! -
Cast in teradata sql
Hello,
Any suggestion in the way I used CAST in TERADATA SQL:
AND CAST (EXCEPTION_EVEN T_TS AS TIMESTAMP(0) FORMAT 'MM/DD/YYYY HH:MI:SS') = EXCEPTION_EVENT _TS
AND EXCEPTION_EVENT _TS BETWEEN '06/05/2009 00:00:00' AND '06/06/2009 00:00:00'
My error is Invalid Timestamp.
Thanks in Advance.
I was able to resolve my error..hehehe Thanks!Last edited by iceman23; Sep 1 '09, 04:47 PM. Reason: I was able to resolve my error..hehehe Thanks! -
Next row value
Hello,
Here is my question to you guys.
Having a list of items for example:
Table Fruits
Name Description
Apple sweet
Orange round
Mango ripe
I queried:
select *
from Fruits
where description like 'sweet'
My result is:
Name Description
Apple sweet
...
No activity results to display
Leave a comment: