HI, U WANT TO DISPLAY MAX TIMESTAMP SO THE QUERY IS SELECT * FROM TABLE

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 / rkraju

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

Answer Posted / rkraju

HI,
U WANT TO DISPLAY MAX TIMESTAMP
SO THE QUERY IS
SELECT * FROM TABLENAME WHERE DATETIMESTAMP IN(SELECT
MAX(DATETIMESTAMP) FROM TABLENAME);

Is This Answer Correct ?

18 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Different phases of multiload?

1016

Is multi insert ansi standard?

2207

What are the various etl tools in the market?

1073

Highlight a few of the important components of Teradata?

1030

How you will check the version of teradata?

1168

What are the things to be considered while creating secondary index?

1101

What is oltp?

978

Name the five phases that come under MultiLoad Utility.

988

Syntax for case when statement?

1068

What is upsert statement in teradata?

1137

List out some of the primary characteristics of teradata.

1009

What is the maximum number of dml can be coded in a multiload script?

1109

What are default access rights in teradata?

1124

What are the different methods ot loading a dimension table? A fact table etc?

1036

Steps to create a data model?

1136