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
- 7722 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
What is the use of stored procedures in teradata?
What is teradata? Also, list out some of the primary characteristics of teradata.
How can bottlenecks be identified?
What are the 5 phases in a multiload utility?
What does sleep function does in fast load?
hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com
How do you create tables? Exact syntax, and create profiles, users in teradata?
What are the components used in smp and massively parallel processing (mpp) machines?
Explain the teradata primary index mechanics in detail with a diagram.
What are the functions of a Parser?
What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?
What do you mean by caching in teradata?
Highlight a few of the important components of Teradata?
What is difference between user and database in teradata?
What exactly do you know about catching in teradata?
