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.

if collect stats but it show low confidence why?

0 Answers   IBM,

---

Explain how spool space is used.

0 Answers  

---

IBM QUESTION As all we know PE takes the SQL Request and it will give responce for that query. what is the internal process happening.how it is taking that sql from the system????? thanks in Advance

2 Answers   Cap Gemini, IBM, Infosys,

---

Which Teradata concept allows more than one model generation?

1 Answers   TCS,

---

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

0 Answers  

---

---

What are the different softwares used with their functions in teradata?

0 Answers  

---

Can we collect statistics on multiple columns?

0 Answers  

---

What are the functions involved in shared information architecture?

0 Answers  

---

Write a program to show the parser component used in teradata?

0 Answers  

---

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

4 Answers  

---

How many types of index are present in teradata?

1 Answers  

---

Explain BYNET.

0 Answers  

---