Answer Posted / alok

Just optimized Hariharan's And


SEL A.STUDENTID,A.STUDENTNAME,
CASE WHEN A.HIGHSUBJ='SUBJECT1'
THEN A.SUBJECT1
END AS SUBJECT1,
CASE WHEN A.HIGHSUBJ='SUBJECT2'
THEN A.SUBJECT2
END AS SUBJECT2,
CASE WHEN A.HIGHSUBJ='SUBJECT3'
THEN A.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
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

1782

---

What are the various indexes in teradata? Why are they preferred?

1053

---

Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?

2000

---

Why is the case expression used in teradata?

1135

---

During the Display time, how is the sequence generated by Teradata?

1120

---

What is difference between user and database in teradata?

1115

---

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

1049

---

if collect stats but it show low confidence why?

1748

---

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

1036

---

What is the syntax for case when statement?

1215

---

How can bottlenecks be identified?

1060

---

what are the uses of fact table and dimension table in banking project?

4600

---

Why are oltp database designs not generally a good idea for a data warehouse?

1103

---

In general, how do you optimze any sql in teradata?

1085

---

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

1103

---