Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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

Answer Posted / gvk

select substr("pravalli nagireddy",instr("pravalli
nagireddy",' '),10)from <tablename>

Is This Answer Correct ?    1 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are some primary characteristics of teradata?

943


How can bottlenecks be identified?

955


What are the various indexes in teradata? Why are they preferred?

955


What are the design features involved in teradata?

973


Name the five phases that come under MultiLoad Utility.

928


What is the purpose of upsert command?

1077


What is multi insert?

983


Define views in teradata with syntax.

1021


What is the function of parser component in teradata?

1035


What is the primary index in teradata?

1110


Did you write stored procedures in teradata?

1057


What are the available primary index types?

1147


What happens when a node suffers a downfall?

1056


How to find duplicates in a table?

1131


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 ?

2417