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
- 12425 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / babu
Hi All,
SELECT SUBSTR('PRAVALLI NAGIREDDY',POSITION('' IN 'PRAVALLI
NAGIREDDY')+1) FROM TABLE_NAME
THIS IS THE CORRECT ANSWER.
IN TERADATA THE FUNCTION INSTR IS NOT WORK.
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / chandu
select substr("pravalli nagireddy",10,9) from <table_name>
| Is This Answer Correct ? | 11 Yes | 6 No |
Answer / tdguy
Use substr function to handle character manipulations.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / kiran kumar
Sel address,index(address,' ') as r,substr(address,r+1) from tablename;
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / nani
select substr(address,position('n'in address))as first_name
from t1;
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / ankal
sel substr('pravalli nagireddy', index('pravalli nagireddy','n'));
| Is This Answer Correct ? | 2 Yes | 3 No |
Answer / nani
SELECT ARRDESS COLUMN FROM TABLE NAME WHERE ADDRESSCOLUMN='%
NAGIREDDY'
| Is This Answer Correct ? | 0 Yes | 5 No |
What are the different methods ot loading a dimension table? A fact table etc?
Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?
Mention a few of the ETL tools that come under Teradata.
What is Difference b/w PI & PPI?how to implement PPI?
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
Explain and compare pros and cons of start schemas?
What do you mean by caching in teradata?
Highlight a few of the advantages that ETL tools have over Teradata.
Explain about Skew Factor?
What are the available primary index types?
Name the five phases that come under MultiLoad Utility.
sel a.t1,b.t1 from emp a left outer join dept b ON a.id=b.id where b.deptno=10; sel a.t1,b.t1 from emp a left outer join dept b ON a.id=b.id and b.deptno=10; what is the difference on the above 2 queries?
Teradata 
