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

SELECT ARRDESS COLUMN FROM TABLE NAME WHERE ADDRESSCOLUMN='%
NAGIREDDY'

Is This Answer Correct ?    0 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the scenarios in which full table scans occurs?

742


Difference between star and snowflake schemas?

805


What is bteq utility in teradata?

728


How to run a query in teradata?

786


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

834


What are the components provided on node?

786


What is the basic syntax for teradata select statement?

758


How to load specific no.of records using bteq, or fastload,or multiload

1514


What is the purpose of upsert command?

801


how do you manage the production space. what are the proactive methods you can take ?

1660


Difference between stored procedure and macro?

905


What are the available primary index types in teradata.

769


What are the different design perspectives used in teradata?

731


Explain the term 'tables' related to relational database management system?

789


what are the uses of fact table and dimension table in banking project?

4308