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

Differentiate primary key and partition key?

1032

---

Can you connect multiload from ab initio?

1280

---

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

1814

---

Difference between stored procedure and macro?

1218

---

In Teradata, how do we Generate Sequence?

1089

---

What do high confidence, low confidence and no confidence mean in explain plan?

1097

---

What do you mean by teradata sql assistant?

1112

---

What are some primary characteristics of teradata?

1051

---

How to view every column and the columns contained in indexes in teradata?

1098

---

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

1317

---

What is bteq utility in teradata?

1024

---

How to select first n records in teradata?

1160

---

What is teradata? Also, list out some of the primary characteristics of teradata.

1128

---

List out teradata data types?

1063

---

In BTEQ, how are the session-mode parameters being set?

1189

---