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
what is object level locking ? where do appear this type of locking ?
Why is the case expression used in teradata?
Explain teradata vs. Redshift?
What is the primary index in teradata?
What are default access rights in teradata?
What are the various indexes in teradata? How to use them? Why are they preferred?
What is the function of parser component in teradata?
What is the use of fallback?
Explain teradata architecture?
Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?
Which is faster fastload or multiload?
What are the available primary index types in teradata.
Explain PDE.
Is multi insert ansi standard?
What is a sparse index?