select substr("pravalli nagireddy",10,9) from <table

"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 / chandu

Answer Posted / chandu

select substr("pravalli nagireddy",10,9) from <table_name>

Is This Answer Correct ?

11 Yes

6 No

Please Help Members By Posting Answers For Below Questions

What is the purpose of using case expression in teradata?

1009

What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?

1105

What is the meaning of Caching in Teradata?

1129

What are the steps to create a data model?

1046

How to select first n records in teradata?

1096

What is upsert statement in teradata?

1121

In Teradata, what is the significance of UPSERT command?

1222

What do you mean by fastexport in teradata?

993

In general, how do you optimze any sql in teradata?

1039

Explain teradata vs. Redshift?

1009

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

1116

What is database exceptions in teradata?

942

what are the day to day activities of teradata DBA ?

5814

What is a node in teradata? Explain

998

What is meant by a node?

1039