Interested to Buy Any Domain ? << Click Here >> for more details...
"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
- 9 Answers
- 12121 Views
- I also Faced
- E-Mail Answers
Answer Posted / yuvaevergreen
sel substr(address,index(address,' ')+1) from db.emp;
will give you the string after the first space in the string.
| Is This Answer Correct ? | 12 Yes | 0 No |
Post New Answer View All Answers
What are different table types used in teradata?
How to identify ppi columns?
What is teradata? What are some primary characteristics of teradata?
What are the 5 phases in a multiload utility?
how can we analyze the locks ?
What are the scenarios in which full table scans occurs?
how do you manage the production space. what are the proactive methods you can take ?
Describe primary index in teradata. And what are the available primary index types?
How is MLOAD Client System restarted after execution?
How do you create tables? Exact syntax, and create profiles, users in teradata?
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 ?
How would you load a very large file in teradata in general?
What is the multi-insert?
How many types of joins are there in teradata?
What are the various indexes in teradata? How to use them?
