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

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

1061

Which is faster fastload or multiload?

1104

How will you solve the problem that occurs during update?

1049

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

1741

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

1040

If Fast Load Script fails and only the error tables are made available to you, then how will you restart?

1148

What are the main components of teradata system?

1123

How many tables can you join in v2r5?

1066

How to view every column and the columns contained in indexes in teradata?

1044

Explain Teradata performance tuning and optimization?

1156

Explain teradata architecture in detail with a diagram.

1111

What is the use of virtual processor connectivity in teradata?

1003

What are the steps to create a data model?

1047

Explain BYNET.

988

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

1939