Interested to Buy Any Domain ? << Click Here >> for more details...
write a query following data.
123.45 is input.write a query after decimal (ex:.45) load
into database ?how it possible?
- 3 Answers
- 7810 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / ankal
assuming this value is sal colume i mean sal=123.45; u want to update it with after decimal value.i think The following query try.
update table_name set sal=sal-cast(sal as int));
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
Mention a few of the ETL tools that come under Teradata.
How to select first n records in teradata?
What are the components provided on node?
What are the 5 phases in a multiload utility?
What is teradata?
Explain the advantages of partitioned primary index in a query?
Can we collect statistics on multiple columns?
What are the different methods ot loading a dimension table? A fact table etc?
What are the string manipulation operators and functions associated with teradata?
What is teradata? Also, list out some of the primary characteristics of teradata.
How many sessions of MAX is PE capable of handling at a particular time?
Explain the parallel data extension in teradata?
What are some commonly used bteq scripts?
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
What is stored procedure in teradata?
