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

How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.

4421

What is the maximum number of dml can be coded in a multiload script?

1154

How does hashing happens in teradata?

1144

Explain PDE.

1127

what are the day to day activities of teradata DBA ?

5860

How do you see a ddl for an existing table?

1058

What are differences between teradata and ansi session modes in teradata?

1215

What is a node in teradata? Explain

1053

what is sysdba and sysdbc ? which has high priority ?

3882

What are the steps involved after the disk manager passes the request?

1180

What are the functions performed by bynet?

1085

how many modules are there in telecome domain?how to explain the architecture?

2064

What is spool space?

1221

What are the components used in smp and massively parallel processing (mpp) machines?

1093

What is the syntax for case when statement?

1214