"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 / chandu
select substr("pravalli nagireddy",10,9) from <table_name>
| Is This Answer Correct ? | 11 Yes | 6 No |
Post New Answer View All Answers
Write a program to show the parser component used in teradata?
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
What are default access rights in teradata?
Which is more efficient group by or distinct to find duplicates?
What are the joins in teradata and how many types of joins are there in teradata?
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
What are the design features involved in teradata?
Syntax for case when statement?
What are the different functions performed in development phase?
How many types of joins are there in teradata?
Explain teradata architecture in detail with a diagram.
What is the purpose of joins in teradata and what are the available join types?
What is bteq script in teradata?
How does hashing happens in teradata?
Explain how spool space is used.