Above answers are correct, but data type should be taken care of.

write a query following data.
123.45 is input.write a query after decimal (ex:.45) load
into database ?how it possible?

Question Posted / tdguy

Answer Posted / tdguy

Above answers are correct, but data type should be taken
care of.

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to eliminate product joins in a teradata sql query?

1043

What is the opening step in basic teradata query script?

1047

Can we collect statistics on table level?

1043

What are the commands to make a new table, change a table and remove a table in teradata?

1137

What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?

1116

Why do you get spool space errors? How do trouble-shoot them?

1063

Explain how spool space is used.

1081

What is bteq script in teradata?

1162

Explain fallback in teradata?

1069

What are the uses of bynets in multi-node systems?

1039

how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u

1750

Did you write stored procedures in teradata?

1138

Give the sizes of SMALLINT, BYTEINT and INTEGER.

1173

What is the basic syntax for teradata select statement?

1051

What is the purpose of using case expression in teradata?

1024