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
- 7719 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / tdguy
If the columntype is timestamp, just max() function would
give you the result.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How do you see a ddl for an existing table?
What is the opening step in basic teradata query script?
If RDBMS is halted what will you do ?
How can bottlenecks be identified?
Explain parsing engine in teradata?
What are the joins in teradata and how many types of joins are there in teradata?
What is the command in bteq to check for session settings ?
if collect stats but it show low confidence why?
What is teradata? What are some primary characteristics of teradata?
What is the maximum number of dml can be coded in a multiload script?
What are the commands to make a new table, change a table and remove a table in teradata?
Explain the term 'foreign key' related to relational database management system?
What can be achieved by using the teradata rdbms?
Explain the meaning of Amp?
Highlight the limitations of TPUMP Utility.
