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
Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!
What are the available join types in teradata?
What is the purpose of indexes?
If RDBMS is halted what will you do ?
What is dimensional modeling?
What is the syntax for case when statement?
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
how many modules are there in telecome domain?how to explain the architecture?
Explain the term 'columns' related to relational database management system?
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
Explain and compare pros and cons of start schemas?
What can be achieved by using the teradata rdbms?
What is teradata and why it is used?
What is meant by a Parsing Engine?
How can you track login parameters of users in teradata?