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 does Amp contain and what are all the operations that it performs?

1007

What is the command in bteq to check for session settings ?

1180

Explain the teradata primary index mechanics in detail with a diagram.

978

What are the enhanced features in teradata v2r5 and v2r6?

1138

List out all forms of LOCKS that are available in Teradata.

969

What is the particular designated level at which a LOCK is liable to be applied in Teradata?

1048

any one answer me how they can analyzing the project using data ware housing?

2480

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

1024

What are the various indexes in teradata? How to use them? Why are they preferred?

1063

Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?

1243

How do you see a ddl for an existing table?

1018

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

988

Write a program to show the parser component used in teradata?

982

What is a sparse index?

1087

What is logical data model?

1210