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

How to select first n records in teradata?

1082

---

Explain fallback in teradata?

1032

---

What is the use of virtual processor connectivity in teradata?

985

---

Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?

2040

---

Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com

2407

---

What are the available primary index types in teradata.

1017

---

What is TPD?

1356

---

What are aggregate tables? How do you design them using teradata?

1154

---

What are the newly developed features of Teradata?

1007

---

What are types of partition primary index (ppi) in teradata?

1032

---

What is the difference between global temporary tables and volatile temporary tables?

1152

---

If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?

2190

---

What are the design features involved in teradata?

1043

---

How can we check the version of Teradata that we are using currently?

1060

---

Explain and compare pros and cons of start schemas?

1044

---