I have a line of code in Oracle and I had to convert it into Teradata. The Oracle query is /* add to avoid invalid number due to junk开发者_开发技巧 in column */
There is this one table which contains the amounts and states that I need. However, this table contains a year information but I want month. For example, in the table it shows information for Kentucky
I am trying to tune a query in Teradata. It\'s pretty huge, so I am giving below the outline: SEL column_1, column_2......column_20, sum(column_21), sum(column_22),.....sum(column_30)
I am trying to fetch a huge set of records from Teradata using JDBC. And I need to break this set into parts for which I\'m using \"Top N\" clau开发者_高级运维se in select.
I have two tab开发者_开发百科les like this I would like to insert from Table1 to Table2 here. This is how I want it.
How do I combine columns and rows in the following example in SQL without pulling extra rows with nulls on columns that not existing in the other table? This should be similar to the OUTER UNION CORR
I keep having the same issue revolving a particula开发者_开发百科r query which has the following column:
Has anyone had any success with this? There aren\'t a great deal of references online and I\'ve exhausted every relevant result on Google. Here\'s my script:
Similar to a question I had earlier Having this table ID, Year, Revenue 1, 2009, 10 1, 2009, 20 1, 2010, 20
Note: Tried a couple of the answers below (its in Teradata, so some of the answers are giving me syntax errors everywhere)
加载中,请稍侯......