Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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

Name the five phases that come under MultiLoad Utility.

0 Answers  

Can we Suggest as how is the process to get a job in teradata in current market??Is it easier???

1 Answers   IBM,

What happens when a node suffers a downfall?

0 Answers  

What is spool space? Why do you get spool space errors? How do trouble-shoot them?

0 Answers  

What are the differences between TerdataV2R5 and V12 Versions please??

3 Answers  

if a error occured in FASTLOAD is the fastload job stops?

1 Answers   CTS, Deloitte,

sel a.t1,b.t1 from emp a left outer join dept b ON a.id=b.id where b.deptno=10; sel a.t1,b.t1 from emp a left outer join dept b ON a.id=b.id and b.deptno=10; what is the difference on the above 2 queries?

3 Answers   CTS,

what is identity columns in TD?

2 Answers   Wipro,

What is meant by Teradata Gateway?

0 Answers  

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 Difference b/w PI & PPI?how to implement PPI?

3 Answers   Wipro,

What is a node in teradata? Explain

0 Answers  

For more Teradata Interview Questions Click Here
Categories