If the columntype is timestamp, just max() function would give you the re

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)

Question Posted / tdguy

2 Answers
7829 Views
TCS, I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

Different phases of multiload?

981

what are the day to day activities of teradata DBA ?

5809

any one answer me how they can analyzing the project using data ware housing?

2455

What happens when a node suffers a downfall?

1110

While creating table my dba has fallback or no fallback in his ddl. What is that?

1157

Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?

1222

Explain and compare pros and cons of start schemas?

1046

What does sleep function does in fast load?

1118

What is the difference between teradata and basic rdbms?

1002

tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you

815

How is the teradata different from oracle?

1085

Steps to create a data model?

1107

Why is the case expression used in teradata?

1067

Explain the parallel data extension in teradata?

1076

What are different table types used in teradata?

1026