Answer Posted / tdguy

SEL A.STUDENTID,A.STUDENTNAME,
CASE WHEN A.HIGHSUBJ='SUBJECT1'
THEN B.SUBJECT1
ELSE C.SUBJECT1
END AS SUBJECT1,
CASE WHEN A.HIGHSUBJ='SUBJECT2'
THEN B.SUBJECT2
ELSE C.SUBJECT2
END AS SUBJECT2,
CASE WHEN A.HIGHSUBJ='SUBJECT3'
THEN B.SUBJECT3
ELSE C.SUBJECT3
END AS SUBJECT3
FROM
(SEL STUDENTID,STUDENTNAME,SUBJECT1 ,SUBJECT2 ,SUBJECT3,
CASE WHEN SUBJECT1 > SUBJECT2 AND SUBJECT1 > SUBJECT3
THEN 'SUBJECT1'
WHEN SUBJECT2 > SUBJECT3
THEN 'SUBJECT2' ELSE 'SUBJECT3'
END AS HIGHSUBJ
FROM STUD1) A
INNER JOIN
(SEL STUDENTID,STUDENTNAME,SUBJECT1 ,SUBJECT2 ,SUBJECT3
FROM STUD1) B
ON A.STUDENTID=B.STUDENTID
INNER JOIN
(SEL STUDENTID,STUDENTNAME,NULL AS SUBJECT1 ,
NULL AS SUBJECT2 ,
NULL AS SUBJECT3 FROM STUD1) C
ON B.STUDENTID=C.STUDENTID
ORDER BY A.STUDENTID

What are the functions performed by bynet?

987

---

What are the various indexes in teradata?

974

---

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

1038

---

What do you mean by teradata intelliflex?

1041

---

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

1015

---

What is the syntax for case when statement?

1060

---

Explain the teradata primary index mechanics in detail with a diagram.

913

---

What is meant by a Parsing Engine?

1133

---

How to load specific no.of records using bteq, or fastload,or multiload

1693

---

What tools would you use for that?

1032

---

Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?

1135

---

What is difference between user and database in teradata?

1027

---

What is the opening step in basic teradata query script?

984

---

How to eliminate product joins in a teradata sql query?

962

---

What is the multi-insert?

969

---