Answer Posted / tdguy

SEL A.STUDENTID,A.STUDENTNAME,
CASE WHEN A.HIGHSUBJ='SUBJECT1'
THEN A.SUBJECT1 ELSE C.SUBJECT1
END AS SUBJECT1,
CASE WHEN A.HIGHSUBJ='SUBJECT2'
THEN A.SUBJECT2 ELSE C.SUBJECT2
END AS SUBJECT2,
CASE WHEN A.HIGHSUBJ='SUBJECT3'
THEN A.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,NULL AS SUBJECT1 ,
NULL AS SUBJECT2 ,NULL AS SUBJECT3 FROM STUD1) C
ON A.STUDENTID=C.STUDENTID
ORDER BY A.STUDENTID

how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u

1714

---

In Teradata, how do we Generate Sequence?

1029

---

What type of indexing mechanism do we need to use for a typical data warehouse?

1150

---

What is the purpose of joins in teradata?

1147

---

Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A

3361

---

Explain Teradata performance tuning and optimization?

1148

---

List out some of the primary characteristics of teradata.

966

---

How is MLOAD Client System restarted after execution?

1125

---

Highlight all the modes that are present under Confidence Level.

964

---

What does sleep function does in fast load?

1118

---

tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you

815

---

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

1026

---

What is the difference between global temporary tables and volatile temporary tables?

1154

---

What are the available primary index types?

1202

---

What is logical data model?

1189

---