Answer / rkraju

HI,
U WANT TO DISPLAY MAX TIMESTAMP
SO THE QUERY IS
SELECT * FROM TABLENAME WHERE DATETIMESTAMP IN(SELECT
MAX(DATETIMESTAMP) FROM TABLENAME);

Answer / tdguy

If the columntype is timestamp, just max() function would
give you the result.

Can we load a Multi set table using MLOAD?

2 Answers  

---

I have a table with emp id, emp name, dept id and sal where dept id is NUSI. SEL * FROM EMP WHERE DEPTID = 100. Can any one explain how it will fetch the record.

4 Answers  

---

How does hashing happens in teradata?

0 Answers  

---

What are the different design perspectives used in teradata?

0 Answers  

---

Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?

0 Answers   IBM,

---

what is the advantages of other etl tool than teradata utilities or vice versa ?(datastage/informatica)

4 Answers  

---

What are the different table types supported by teradata?

0 Answers  

---

On which column will you take primary index???

4 Answers  

---

What is a three-tier data warehouse?

0 Answers  

---

any one answer me how they can analyzing the project using data ware housing?

0 Answers  

---

How can we load single row of data into teradata database. please give me the process.

3 Answers  

---

What is the syntax for case when statement?

0 Answers  

---