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 |
What do you mean by tpt in teradata?
What are the steps involved in the process flow of the sql statement through channel attached system?
Hello Frndz, I have a table named product as shown below: product_id product_name 1 AAA 1 BBB 1 CCC 2 PPP 2 QQQ 2 RRR Now my output should be: product_id product_name_1 product_name_2 product_name_3 1 AAA BBB CCC 2 PPP QQQ RRR
How to improve the query performance without taking the collect statistics? In explain plan i have 'NO CONFIDENT'.
1.what is activity count? 2.what is skew factor? how it's working explain brefily
What is a dimension table?
Explain the types of join supports by teradata?
Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?
Can we collect statistics on multiple columns?
What are the functions performed by bynet?
Explain the term 'database' related to relational database management system?
Can you connect multiload from ab initio?