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

Explain PDE.

1074

What are the multiload utility limitations?

1045

In BTEQ, how are the session-mode parameters being set?

1143

What exactly do you know about catching in teradata?

1036

How to select first n records in teradata?

1100

What is difference between user and database in teradata?

1065

What is the opening step in basic teradata query script?

1037

What is spool space? Why do you get spool space errors?

1015

What are aggregate tables? How do you design them using teradata?

1166

tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you

827

What is meant by a Least Cost Plan?

1057

Explain teradata vs. Redshift?

1011

Why managing the data is important?

1013

What is called partitioned primary index (ppi)?

1008

What are the joins in teradata?

987