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
- 12114 Views
- I also Faced
- E-Mail Answers
Answer Posted / nani
select substr(address,position('n'in address))as first_name
from t1;
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the difference between teradata and basic rdbms?
During the Display time, how is the sequence generated by Teradata?
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
What is database exceptions in teradata?
Explain the advantages of partitioned primary index in a query?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
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 ?
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
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?
What exactly do you know about catching in teradata?
What are the string manipulation operators and functions associated with teradata?
Explain fastload in teradata?
How do you verify a complicated sql?
What is spool space? Why do you get spool space errors?
Which is faster fastload or multiload?
