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 happens when a node suffers a downfall?

1140

---

Discuss the advantages of using partitioned primary index in a query?

959

---

what is object level locking ? where do appear this type of locking ?

3503

---

Explain the new features of teradata?

1046

---

What is a dimension table?

1072

---

What is bteq utility in teradata?

985

---

Explain the meaning of Amp?

1156

---

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

974

---

How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .

1776

---

Explain some differences between mpp and smp?

1109

---

Explain how spool space is used.

1081

---

any one answer me how they can analyzing the project using data ware housing?

2483

---

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

1075

---

What is spool space? Why do you get spool space errors? How do trouble-shoot them?

992

---

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

1101

---