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
- 7985 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / yuvaevergreen
Assuming the column type to be decimal type and the same table to be updated, the string function can be used.
update dbname.tbname
set salary=
substr(cast (salary as char(10)),index(cast (salary as char(10)),'.'))
>>>salary is of type decimal..
| Is This Answer Correct ? | 7 Yes | 1 No |
Answer / 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 |
Answer / tdguy
Above answers are correct, but data type should be taken
care of.
| Is This Answer Correct ? | 1 Yes | 0 No |
I want to write one query How to get Matched records and unmatched records in table?
If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.
What exactly do you know about catching in teradata?
In Teradata, what is the significance of UPSERT command?
Why Multiload does not supports USI and supports NUSI?
Hi Friends I have a sql question, We have the source data as below. 101 address1, address2, address3 and the output shoulb like below 101 address1 101 address2 101 address3 Required a SQL query for this output. Please let me know if you have any sql query for this. Thanks in advance. Hari M
Differentiate primary key and partition key?
What do you mean by ttu in teradata?
Name the five phases that come under MultiLoad Utility.
Write a program to show the parser component used in teradata?
What is differnce between Error code and Error Level in Bteq
what is object level locking ? where do appear this type of locking ?
Teradata 
