write a query following data.
123.45 is input.write a query after decimal (ex:.45) load
into database ?how it possible?
- 3 Answers
- 6653 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
How to Extract data from multiple legacy systems?
What are the functions involved in shared information architecture?
i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com
What type of indexing mechanism do we need to use for a typical data warehouse?
Explain fastload in teradata?
What are the various indexes in teradata? How to use them? Why are they preferred?
Define views in teradata with general syntax.
What is bteq utility in teradata?
What is multi insert?
What are the functions of a Parser?
How is the teradata different from oracle?
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
What are the joins in teradata and how many types of joins are there in teradata?
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
Comment whether bottleneck is an error or not.
