#DateForumTypeThreadPost
1011 Oct 2015 @ 07:09 PDTDatabaseReplyIssu With Decimal DatatypeHave you tried Casting function in your query?
917 Sep 2015 @ 07:31 PDTDatabaseReplyCase StatementHi,   CREATE TABLE APPLICATION( Appl_Id INTEGER, Status INTEGER, Status_Desc VARCHAR); INSERT INTO APPLICATION VALUES ('12345678','1','ENTERED'); INSERT ...
816 Sep 2015 @ 09:47 PDTDatabaseReplySUBSTRING and CONCATENATIONHi, To get the count : SELECT SUBSTR(field, 2,7)||SUBSTR(field, 11,3), COUNT(*) FROM DB.TABLE WHERE FIELD = 'XX' GROUP BY 1;  
715 Sep 2015 @ 08:40 PDTDatabaseReplyUnpack column valuesHi, I Guess your requirement is to convert ROWS into COLUMNS. Is it right? If so then below is the query:   sel col1 from pack.table union sel col2 from pack.table    
611 Sep 2015 @ 09:08 PDTDatabaseReplyhow to get rows with a blank value in a column  Hi, You have to use coalesce function to get the result.   Saravanan
509 Sep 2015 @ 09:02 PDTDatabaseReplyhow to get rows with a blank value in a columnHi, Your sql query is correct.  In (IS NULL) keyword space should be removed and it should be ISNULL .  I think one space is enough...
409 Sep 2015 @ 06:33 PDTDatabaseReplyTeradata Query to handle previous day amountHi, Kindly let me know that the below query fits in your requirement: select ID,PAY_DATE,AMOUNT,PREVIOUS_AMT from (select  ID,PAY_DATE,AMOUNT,(AMOUNT+coalesce(max(AMOUNT)over(order by...
307 Sep 2015 @ 04:03 PDTDatabaseReplyNeed a query Hi, This is the query you are looking for : SELECT * FROM (SELECT EMPLOYEE_ID,EMPLOYEE_NAME FROM STORE union SELECT EMPLOYEE_ID,EMPLOYEE_NAME FROM STORE1)B WHERE B.EMPLOYEE_ID NOT IN ( S...
204 Sep 2015 @ 07:15 PDTGeneralReplyHow to find CONSECUTIVE values coming in a column(TERADATA)    Hi, I think below query will give the result you are looking for: select employee_id,case when tr=1 then 'yes' else 'no' end as sequence from (select  ...
109 Jul 2011 @ 09:58 PDTDatabaseReplySample FunctionHi, Iam a fresher in teradata.Iam able to join one source table to target table.But iam unable to join many source table to target source in a single query.