Answer Posted / vishvajeet solanke

TRY THIS ONE..ITS SIMPLE


CREATE VOLATILE TABLE TEST
(e_NAME VARCHAR(10),SUB1 INTEGER,SUB2 INTEGER,SUB3 INTEGER)
ON COMMIT PRESERVE ROWS;

INSERT INTO TEST (e_NAME,SUB1,SUB2,SUB3) VALUES('AAA',85,95,92);
INSERT INTO TEST (e_NAME,SUB1,SUB2,SUB3) VALUES('BBB',75,67,82);

SEL E_NAME,MAX(SUBJECT) FROM
(SEL E_NAME,SUB1 AS SUBJECT
FROM TEST
UNION
SEL E_NAME,SUB2 AS SUBJECT
FROM TEST
UNION
SEL E_NAME,SUB3 AS SUBJECT
FROM TEST
) TS
GROUP BY 1

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

1038

---

What do you mean by teradata sql assistant?

1000

---

How is MLOAD Teradata Server restarted after execution?

1172

---

How can bottlenecks be identified?

958

---

How to identify ppi columns?

1105

---

What are teradata utilities?

1037

---

What are the frequently used data types in teradata?

1008

---

List the logical and conditional operators that are used with teradata along with their meanings?

944

---

What is teradata and why it is used?

1017

---

What is meant by a node?

995

---

Can you fastexport a field, which is primary key by putting equality on that key?

1118

---

Describe the set operators in teradata.

956

---

What is the basic syntax for teradata select statement?

986

---

Explain the new features of teradata?

992

---

What do you mean by caching in teradata?

998

---