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)
Answer Posted / tdguy
If the columntype is timestamp, just max() function would
give you the result.
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
Explain the teradata primary index mechanics in detail with a diagram.
Name the five phases that come under MultiLoad Utility.
What are the uses of client software involved in teradata?
Explain the term 'tables' related to relational database management system?
What are default access rights in teradata? What explicit right can be given to a user?
What is meant by a Least Cost Plan?
Why do you get spool space errors? How do trouble-shoot them?
How do you verify a complicated sql?
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.
Explain the parallel data extension in teradata?
Difference between inner join and outer join?
What are teradata utilities?
What do you mean by ttu in teradata?
How is MLOAD Client System restarted after execution?