What's the syntax of sub string?
Answer / lakshma naik
Select * from table_name
where column_name in (select column_name from table_name)
Is This Answer Correct ? | 0 Yes | 0 No |
i have column like below studentid studentname sub1 sub2 sub3 1 aaa 40 70 90 2 bbb 60 80 50 i want to execute every student highest mark in which subject my o/p like below studentid studentname sub3 sub2 1 aaa 90 2 bbb 80
Why managing the data is important?
How do you verify a complicated sql?
I want to load 1000 rcds using. FL for every 100 records there is a check point.But script failed at 120 records, when we are restarting the script, it starts from last ckpt, but Target table contains populated data but FL doesnt support existing data in target table. How can we load data in FL?
What are the different table types that are supported by teradata?
What is meant by a Clique?
what is the difference between bpo and call centre?
Can some one tell me the ressolution for the error. I was not able to answer this question in wipro interview. "The transaction exceeded the maximum number of rowhash locks allowed"
Highlight the differences between Primary Key and Primary Index.
Which is faster fastload or multiload?
What are the various indexes in teradata?
What is the difference between global temporary tables and volatile temporary tables?