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
7986 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

How do you verify a complicated sql?

1115

What do you mean by teradata intellicloud?

1077

How to view every column and the columns contained in indexes in teradata?

1100

What are the available join types in teradata?

1115

Explain the parallel data extension in teradata?

1152

Explain the most common data types used in teradata?

1125

What are differences between teradata and ansi session modes in teradata?

1218

Explain PDE.

1132

Define views in teradata with general syntax.

1087

How do you define Teradata?

1087

What are the steps involved in the process flow of the sql statement through channel attached system?

1161

what are the day to day activities of teradata DBA ?

5860

What is the basic syntax for teradata select statement?

1096

Define views in teradata with syntax.

1127

What are the functions of a Parser?

1188