"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 / ankal
sel substr('pravalli nagireddy', index('pravalli nagireddy','n'));
Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
What are default access rights in teradata? What explicit right can be given to a user?
What is a node in teradata?
What is smp and mpp platforms?
What is the primary index in teradata?
What is basic teradata query language?
Can we collect statistics on multiple columns?
What is primary index and secondary index?
What is the difference between global temporary tables and volatile temporary tables?
If Fast Load Script fails and only the error tables are made available to you, then how will you restart?
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 ?
Describe primary index in teradata. And what are the available primary index types?
Explain teradata utilities. What is multiload, fast load, tpump?
Highlight the advantages of PPI(Partition Primary Index).
How to view every column and the columns contained in indexes in teradata?
Which is more efficient group by or distinct to find duplicates?