whether Nulls will be counted while doing average? example: we have table column A with following values A -- 5 Null 8 3 Now what is the average of A?

5 Answers   HCL,

---

Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?

0 Answers  

---

can I use “drop” statement in the utility “fload”?

2 Answers   Accenture, CTS, NTT Data,

---

Difference between Qualify and group

4 Answers   CTS,

---

Hello all, There is a table with 4 columns in that 3 columns has been already loaded with 5 million records.4th column is empty,Now I have got 5 million records data which has to be loaded into 4th column.How can I load this data fastly in to the 4th column with out using update

5 Answers   CTS, TCS,

---

How many macros we can create inside a macro

1 Answers   Wipro,

---

What are the various indexes in teradata? How to use them?

0 Answers  

---

can we have an unconnected lkp to lookup a DB2 record against a Teradata record?

3 Answers  

---

Please tell me a query to find the Primary key,Foreign key,primary Index,PPI for the Database?

5 Answers  

---

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

0 Answers  

---

What is meant by a Virtual Disk?

0 Answers  

---

TCS recently asked this question I have records like below Emp id Empname Salary DateTimestamp 1 AA 6000 20120609:11:30 1 AA 7000 20120609:12:30 1 AA 8000 20120609:01:30 I want to exceute records max timestamp(20120609:01:30)

2 Answers   TCS,

---