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 do you mean by caching in teradata?

827

How will you solve the problem that occurs during update?

802

What is the difference between teradata and oracle?

778

Is multi insert ansi standard?

1950

What is teradata?

851

What is meant by a dispatcher?

784

What are the enhanced features in teradata v2r5 and v2r6?

914

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

809

Explain teradata architecture?

853

How do you create tables? Exact syntax, and create profiles, users in teradata?

782

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

768

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

805

What do high confidence, low confidence and no confidence mean in explain plan?

810

Explain teradata architecture in detail with a diagram.

848

Give a justifiable reason why Multi-load supports NUSI instead of USI.

905