Select * from table_name where column_name in (select column

What's the syntax of sub string?

Question Posted / lakshma naik

Answer Posted / lakshma naik

Select * from table_name
where column_name in (select column_name from table_name)

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?

970

What is database exceptions in teradata?

904

Explain teradata utilities. What is multiload, fast load, tpump?

958

What are the enhanced features in teradata v2r5 and v2r6?

1088

What are the functions of a teradata dba?

1032

Explain teradata architecture in detail with a diagram.

1059

What are the various etl tools in the market?

1024

What is TPD?

1317

What is spool space? Why do you get spool space errors? How do trouble-shoot them?

944

What are tpump utility limitations?

1070

Difference between multiload and tpump?

1051

What is the use of stored procedures in teradata?

946

Explain teradata architecture?

1037

In Teradata, what is the significance of UPSERT command?

1143

What do you mean by teradata sql assistant?

1005