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.

How do you create a table with an existing structure of another table with data and with no data?

1 Answers  

---

What are the joins in teradata and how many types of joins are there in teradata?

0 Answers  

---

Why managing the data is important?

0 Answers  

---

sel a.t1,b.t1 from emp a left outer join dept b ON a.id=b.id where b.deptno=10; sel a.t1,b.t1 from emp a left outer join dept b ON a.id=b.id and b.deptno=10; what is the difference on the above 2 queries?

3 Answers   CTS,

---

In which phase of the Active Data Warehouse evolution do you use data to determine what will happen?

2 Answers   IBM, Wipro,

---

What is a pseudo key? What is its use???

2 Answers   Mphasis,

---

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

3 Answers  

---

Where is teradata rdbms used?

0 Answers  

---

if collect stats but it show low confidence why?

0 Answers   IBM,

---

we have two tables emp,dept.emp has eno,ename,sal and dept has deptno,dname.how to find maxsal of each dept wise.which join used for joining.

5 Answers   Accenture, Cognizant,

---

What is a level of granularity of a fact table?

0 Answers  

---

can i call router is a passive transformation

2 Answers  

---