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
- 7994 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
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
What are the things to be considered while creating secondary index?
Did you write stored procedures in teradata?
What are the string manipulation operators and functions associated with teradata?
What is the purpose of joins in teradata and what are the available join types?
Difference between inner join and outer join?
What are the various reporting tools in the market?
What is the primary index in teradata?
What is the use of having index on table?
What is a node in teradata? Explain
What is the difference between teradata and oracle?
How to run a query in teradata?
Explain the term 'foreign key' related to relational database management system?
What happens when a node suffers a downfall?
What are the different functions included in the server software?
