"pravalli nagireddy" record is there in address column but i
want display only 'nagireddy' from the main string what is
query for that pls tell me
Answer Posted / kiran kumar
Sel address,index(address,' ') as r,substr(address,r+1) from tablename;
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are the different table types supported by teradata?
how do you manage the production space. what are the proactive methods you can take ?
What are the different functions included in the server software?
What are the steps involved in the process flow of the sql statement through channel attached system?
What are the uses of bynets in multi-node systems?
Explain fallback in teradata?
How to select first n records in teradata?
What is teradata?
Explain some differences between mpp and smp?
Explain Teradata performance tuning and optimization?
What does sleep function does in fast load?
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
What is partitioned primary index (ppi)?
Highlight the need for Performance Tuning.
Describe the between keyword in teradata?