"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 / gvk
select substr("pravalli nagireddy",instr("pravalli
nagireddy",' '),10)from <tablename>
| Is This Answer Correct ? | 1 Yes | 7 No |
Post New Answer View All Answers
What are some primary characteristics of teradata?
How can bottlenecks be identified?
What are the various indexes in teradata? Why are they preferred?
What are the design features involved in teradata?
Name the five phases that come under MultiLoad Utility.
What is the purpose of upsert command?
What is multi insert?
Define views in teradata with syntax.
What is the function of parser component in teradata?
What is the primary index in teradata?
Did you write stored procedures in teradata?
What are the available primary index types?
What happens when a node suffers a downfall?
How to find duplicates in a table?
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 ?