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
7885 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 many codd's rules are satisfied by teradata database?

1120

What is meant by a node?

1048

What are the steps involved after the disk manager passes the request?

1130

Difference between star and snowflake schemas?

1163

What are different table types used in teradata?

1050

What is a clique?

1109

What is a dimension table?

1073

how can we analyze the locks ?

2138

What are the string manipulation operators and functions associated with teradata?

1106

What is spool space? Why do you get spool space errors?

1033

Highlight a few of the advantages that ETL tools have over Teradata.

1094

What are the design features involved in teradata?

1073

what is sysdba and sysdbc ? which has high priority ?

3840

Explain and compare pros and cons of start schemas?

1083

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

838