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
- 12452 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 is a sparse index?
What are the multiload utility limitations?
Can we collect statistics on table level?
What are the different functions performed in development phase?
Explain and compare pros and cons of start schemas?
What is the difference between teradata and oracle?
What interface is used to connect to windows based applications?
What are default access rights in teradata? What explicit right can be given to a user?
i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com
What are the available primary index types?
What is a level of granularity of a fact table?
How can we check the version of Teradata that we are using currently?
Explain BYNET.
What is upsert statement in teradata?
Explain the advantages of partitioned primary index in a query?
