select substr(address,position('n'in address))as first

"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

Question Posted / nani

Answer Posted / nani

select substr(address,position('n'in address))as first_name
from t1;

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are the different table types supported by teradata?

699

What are the steps involved in the process flow of the sql statement through channel attached system?

838

How do you verify a complicated sql?

810

What are the scenarios in which full table scans occurs?

726

Can you fastexport a field, which is primary key by putting equality on that key?

935

What is primary index and secondary index?

766

How to run a query in teradata?

774

What is oltp?

734

How can we check the version of Teradata that we are using currently?

796

What is the difference between union and union all in teradata?

803

What is a three-tier data warehouse?

791

What is the meaning of Caching in Teradata?

864

How do you do backup and recovery in teradata?

750

Explain teradata vs. Redshift?

715

Mention a few of the ETL tools that come under Teradata.

816