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)
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
Name the five phases that come under MultiLoad Utility.
What is a clique?
Explain Teradata performance tuning and optimization?
What is meant by a Least Cost Plan?
What is the purpose of upsert command?
Explain some differences between mpp and smp?
What is the purpose of joins in teradata?
Explain fastload in teradata?
What are the available primary index types in teradata.
What is a node in teradata? Explain
What are the functions involved in shared information architecture?
How many codd's rules are satisfied by teradata database?
What is a level of granularity of a fact table?
Highlight all the modes that are present under Confidence Level.
What is meant by a dispatcher?