| # | Date | Forum | Type | Thread | Post |
|---|
| 5 | 31 Aug 2012 @ 04:57 PDT | Teradata Applications | Reply | IF Column1 = Column2 => Merge data of Column3 in one cell |
Based on Ulrich's response for http://forums.teradata.com/forum/database/parent-child-relationship-flattening
Please find below query:
Create volatile tabl... |
| 4 | 10 Aug 2012 @ 12:26 PDT | Database | Reply | Joining on multiple tables in teradata |
the table db4.tb1 has already been included in the query i have written....
Select
a.leg,c.btn,p.prods,svc.sr,speed.test,b.acct_id,d.emp_ no,d.emp_name
F... |
| 3 | 09 Aug 2012 @ 01:50 PDT | Database | Reply | Joining on multiple tables in teradata |
Is this the way u wanted it???
Select
a.leg,c.btn,p.prods,svc.sr,speed.test,b.acct_id,d.emp_no,d.emp_name
FROM db1.tb1 as a
INNER JOIN db1.tb2 ... |
| 2 | 09 Aug 2012 @ 01:29 PDT | Database | Reply | Issue regarding Ordered Analytical Functions |
Thanks Ulrich..It wrkd
- GK
|
| 1 | 08 Aug 2012 @ 04:19 PDT | Database | Topic | Issue regarding Ordered Analytical Functions |
Hi there,
To explain you guys, i have created the below volatile table.
CREATE VOLATILE TABLE TEMP1
(c integer,
dt1 date,
cnt i... |
|
|