1. Categories >> Software >> Data Warehouse >> Teradata
  2. Suggest New Category

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)

Question Posted / guest

Answers were Sorted based on User's Feedback



TCS recently asked this question I have records like below Emp id Empname Salary DateTimest..

Answer / 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

TCS recently asked this question I have records like below Emp id Empname Salary DateTimest..

Answer / 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

More Teradata Interview Questions

How do you design aggregate tables using teradata?

1 Answers  

What's the syntax of sub string?

1 Answers  

what is meant by Hot amp?

2 Answers   IBM, Satyam,

Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong

0 Answers  

What is the difference between teradata and oracle?

0 Answers  




how teradata fetches a row from primary index table?

1 Answers  

Highlight the advantages of PPI(Partition Primary Index).

0 Answers  

Explain the most common data types used in teradata?

0 Answers  

Increasing no of amps will increase performance. Is this true?

5 Answers   Infosys,

If Fast Load Script fails and only the error tables are made available to you, then how will you restart?

0 Answers  

Is PK concept available in Teradata. If it is how can we create Primary Key for a table in TD

6 Answers   Wipro,

Explain Teradata performance tuning and optimization?

0 Answers  

For more Teradata Interview Questions Click Here
Categories