write a query following data.
123.45 is input.write a query after decimal (ex:.45) load
into database ?how it possible?
- 3 Answers
- 6673 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
Differentiate database data and data warehouse data?
What are the string manipulation operators and functions associated with teradata?
what is sysdba and sysdbc ? which has high priority ?
If RDBMS is halted what will you do ?
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.
What is logical data model?
What is database exceptions in teradata?
What are the primary characteristics of the Teradata.
What are the different design perspectives used in teradata?
What is difference between user and database in teradata?
What is TPD?
What happens when a node suffers a downfall?
What is teradata? What are some primary characteristics of teradata?
Where is teradata rdbms used?
Why managing the data is important?
