"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
- 10863 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 the multi-insert?
When tpump is used instead of multiload?
What are the uses of bynets in multi-node systems?
Highlight the advantages of PPI(Partition Primary Index).
What do you mean by caching in teradata?
If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.
Explain vproc in teradata?
What are differences between teradata and ansi session modes in teradata?
Why is the case expression used in teradata?
What are the design features involved in teradata?
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
How to run a query in teradata?
Explain parsing engine in teradata?
Explain PDE.
There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?
