"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
Can we collect statistics on table level?
What is the purpose of upsert command?
What are the different methods ot loading a dimension table? A fact table etc?
How do you verify a complicated sql?
What are default access rights in teradata? What explicit right can be given to a user?
What are the different table types that are supported by teradata?
How do you set the session mode parameters in bteq?
What does sleep function does in fast load?
what are the day to day activities of teradata DBA ?
What is the difference between global temporary tables and volatile temporary tables?
What happens in a conflict? How do you handle that?
What are the available primary index types in teradata.
Explain the types of join supports by teradata?
What is the purpose of using case expression in teradata?
What is the purpose of joins in teradata and what are the available join types?