Interested to Buy Any Domain ? << Click Here >> for more details...
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)
- 2 Answers
- 7867 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
Explain PDE.
What do you mean by teradata sql assistant?
During the Display time, how is the sequence generated by Teradata?
What is collect statistics?
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
What is called partitioned primary index (ppi)?
What is primary index and secondary index?
What is meant by a Parsing Engine?
What are the steps to create a data model?
Explain the new features of teradata?
What tools would you use for that?
What are default access rights in teradata? What explicit right can be given to a user?
A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?
How many tables can you join in v2r5?
Explain the teradata primary index mechanics in detail with a diagram.
