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 the script is aborted. why it is aborted and how can you identify ?

1 Answers  

---

id name gender 1 Ram Female 2 Kumar Female 3 sathish Female 4 Santhya Male 5 Durga Male 6 Priya Male This is my input...how to change Gender Male to Female & Female to Male??? Write sql query for this question???

6 Answers   Cap Gemini,

---

How to find No. of Records present in Each AMP or a Node for a given Table through SQL?

2 Answers   IBM,

---

What are the primary characteristics of the Teradata.

0 Answers  

---

What EXPLAIN does in Teradata, what is High confidence, Low confidence and No confidence.. And How we improve the query performance .

5 Answers   Accenture,

---

---

What is the purpose of joins in teradata and what are the available join types?

0 Answers  

---

What is the use of teradata system software?

0 Answers  

---

How a Referential integrity is handled in Teradata?

5 Answers  

---

Comment whether bottleneck is an error or not.

0 Answers  

---

What is basic teradata query language?

0 Answers  

---

Explain the new features of teradata?

0 Answers  

---

how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u

0 Answers  

---