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
- 12411 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 meant by a dispatcher?
What is meant by Teradata Gateway?
Explain fallback in teradata?
What are the components provided on node?
What are the steps involved after the disk manager passes the request?
Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?
if collect stats but it show low confidence why?
What is a node in teradata?
What exactly do you know about catching in teradata?
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
Describe primary index in teradata. And what are the available primary index types?
What is collect statistics?
What is the difference between fastload and multiload? Which one is faster?
What is the difference between fastload and multiload?
What is the basic syntax for teradata select statement?
