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

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

5 Answers   Infosys,

What do you mean by ttu in teradata?

0 Answers  

How do you create tables? Exact syntax, and create profiles, users in teradata?

0 Answers  

What is the purpose of indexes?

0 Answers  

Can we collect statistics on multiple columns?

0 Answers  

I WANT TO LEARN TERA-DATA ,SO CAN ANY BODY PLZ REFER WHAT ARE THE TOPICS I HAVE TO GO THROUGH, TO GET ASAP JOB ,SO PLZ REFER ME WHERE I CAN GET NICE COACHING ON TERADATA.

13 Answers  

Highlight a few of the advantages that ETL tools have over Teradata.

0 Answers  

What are the advantages of teradata?

0 Answers  

how to delete duplicate records in multi set table without using any tables

2 Answers   Accenture, Nest, South Nests Software Solution, Spiro Solutions,

How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.

0 Answers   Infosys, Wells Fargo,

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

1 Answers   CTS, Deloitte,

What is the opening step in basic teradata query script?

0 Answers  

For more Teradata Interview Questions Click Here
Categories