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

how can we analyze the locks ?

2136

---

If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?

2482

---

Highlight the limitations of TPUMP Utility.

1116

---

What is node? How many nodes and amps used in your previous project?

1111

---

What do you mean by parsing?

1117

---

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

1169

---

How do you see a ddl for an existing table?

1019

---

how do you manage the production space. what are the proactive methods you can take ?

1952

---

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

1064

---

What are the joins in teradata?

1020

---

What is oltp?

983

---

Explain fastload in teradata?

1113

---

What is the use of teradata system software?

1041

---

Explain PDE.

1086

---

What are the various reporting tools in the market?

1074

---