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

How to select first n records in teradata?

1163

What is basic teradata query language?

1164

Explain the teradata primary index mechanics in detail with a diagram.

1040

What are the different design perspectives used in teradata?

1036

What is the use of teradata system software?

1090

How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .

1828

In BTEQ, how are the session-mode parameters being set?

1191

Syntax for case when statement?

1118

If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?

2243

What are default access rights in teradata? What explicit right can be given to a user?

1148

What's the difference between timestamp (0) and timestamp (6)?

1257

Highlight the need for Performance Tuning.

1157

What do you mean by teradata sql assistant?

1115

What is the opening step in basic teradata query script?

1093

Difference between multiload and tpump?

1163