What's the syntax of sub string?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.

1668


Difference between multiload and tpump?

617


List out some of the primary characteristics of teradata.

554


How is MLOAD Teradata Server restarted after execution?

648


Differentiate primary key and partition key?

577






What is bteq script in teradata?

631


Highlight the advantages of PPI(Partition Primary Index).

560


What are the various reporting tools in the market?

613


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

652


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

543


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

598


What can be achieved by using the teradata rdbms?

623


What are the things to be considered while creating secondary index?

628


Highlight all the modes that are present under Confidence Level.

537


What is inner join and outer join?

612