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

Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?

3610

---

If Fast Load Script fails and only the error tables are made available to you, then how will you restart?

1138

---

What is the difference between union and union all in teradata?

1110

---

In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?

1150

---

What is basic teradata query language?

1091

---

What are the available primary index types in teradata.

1019

---

why use references rather than pointers in the public api, particularly for arguments which are modified?

986

---

What are the different table types that are supported by teradata?

992

---

What is the use of fallback?

977

---

What is difference between user and database in teradata?

1058

---

What are the joins in teradata?

968

---

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

3478

---

How many types of joins are there in teradata?

959

---

Explain teradata utilities?

1023

---

How to find duplicates in a table?

1195

---