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
- 12417 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 is the syntax for case when statement?
What are the commands to make a new table, change a table and remove a table in teradata?
Where is teradata rdbms used?
Why MLOAD needs Work Tables?
What is the meaning of Caching in Teradata?
How can bottlenecks be identified?
What is basic teradata query language?
i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com
What are the steps to create a data model?
I have a employee table with EMPID, EMPNAME, DEPTID, SAL and want to fetch the maximum and minimum salary on each dept id with the emp name. Can anyone help in this? The result should contain the EMPNAME, DEPTID, SAL.
Hi friends This is suneel and i am new to teradata. In both situvations teradata administrator and teradata sql assitant 12.0 1)How to create database in teradata and under database how to create user. 2)How to create table under that user and giving privilizes to that user. Thanks alot.
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?
Teradata 
