Answer Posted / rkraju

select case when jan>feb and jan>mar and jan> apr and jan>
may and jan>jun then
jan else (case when feb>jan and feb>mar and feb>apr and
feb>may and feb>jun then
feb else (case when mar>jan and mar>feb and mar>apr and
mar>may and mar>jun then
mar else (case when apr>jan and apr>feb and apr>mar and
apr>may and apr>jun then
apr else (case when may>jan and may>feb and may>apr and
may>mar and may>jun then
may else (case when jun>jan and jun>feb and jun>mar and
jun>apr and jun>may then
jun end)end)end)end)end)end from sales;
upto dec we can use similar query to get the max sales from
that sales table i hope u undertand if u have any queries
reach me ravikiran.mca.vadali@gmail.com

Different phases of multiload?

1065

---

What tools would you use for that?

1157

---

There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?

1153

---

What is the use of having index on table?

1043

---

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

1108

---

Explain PDE.

1132

---

List the logical and conditional operators that are used with teradata along with their meanings?

1042

---

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

3696

---

Highlight the differences between Primary Key and Primary Index.

1148

---

Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!

2243

---

What is difference between user and database in teradata?

1117

---

What are the different design perspectives used in teradata?

1036

---

What do you mean by parsing?

1163

---

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

2091

---

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

1056

---