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

Why teradata is used?

1051

---

Explain the term 'columns' related to relational database management system?

1118

---

how many modules are there in telecome domain?how to explain the architecture?

2064

---

Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?

1317

---

What is database exceptions in teradata?

999

---

What are the joins in teradata?

1071

---

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

1229

---

Is multi insert ansi standard?

2250

---

How do you set the session mode parameters in bteq?

1139

---

What is teradata? What are some primary characteristics of teradata?

1026

---

What is called partitioned primary index (ppi)?

1054

---

How does hashing happens in teradata?

1145

---

What are the advantages of teradata?

1058

---

Explain parsing engine in teradata?

1141

---

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

2468

---