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
- 7958 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
What are the different functions included in the server software?
What is stored procedure in teradata?
What are the joins in teradata and how many types of joins are there in teradata?
Explain the new features of teradata?
Why does varchar occupy 2 extra bytes?
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
List out all forms of LOCKS that are available in Teradata.
What are teradata utilities?
What are the available primary index types in teradata.
What do you mean by fastexport in teradata?
Difference between inner join and outer join?
Why is the case expression used in teradata?
Explain the most common data types used in teradata?
What is the primary index in teradata?
Give the sizes of SMALLINT, BYTEINT and INTEGER.
