"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 / 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 do you mean by ttu in teradata?
In BTEQ, how are the session-mode parameters being set?
What are default access rights in teradata?
How can bottlenecks be identified?
What is the purpose of upsert command?
What is difference between user and database in teradata?
Give a justifiable reason why Multi-load supports NUSI instead of USI.
Explain the most common data types used in teradata?
Difference between inner join and outer join?
Write a program to show the parser component used in teradata?
Difference between star and snowflake schemas?
hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com
Explain teradata utilities?
What is the difference between teradata and oracle?
What are the main components of teradata system?