Hi Frnds this que is recently asked at IBM
there are two rows like aa6588fhfhf,gru282vbvv.
Question is howcan we retrive the first number from two
rows.
Can any one help
thanks in advance
Answer Posted / santosh
sel regexp_substr('aa6588fhfhf','[[:digit:]]+')
Ans:6588
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the purpose of joins in teradata?
What is a clique?
How many types of joins are there in teradata?
If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
Explain BYNET.
What is spool space?
Can we collect statistics on multiple columns?
How is the teradata different from oracle?
What is meant by a Parsing Engine?
Explain amp in teradata?
How do you verify a complicated sql?
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
Explain the term 'primary key' related to relational database management system?
Why is the case expression used in teradata?