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

Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!

0 Answers   HP,

Write a single SQL to delete duplicate records from the a single table based on a column value. I need only Unique records at the end of the Query.

13 Answers  

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,

How does hashing happens in teradata?

0 Answers  

Which is faster fastload or multiload?

0 Answers  

What is the opening step in basic teradata query script?

0 Answers  

What is database exceptions in teradata?

0 Answers  

Explain PDE.

0 Answers  

We are migrating an oracle table into teradata, the volume of data is huge and partitioned (year wise list partition). How do i simulate the same in teradata.

2 Answers   IBM,

What is the diffrence between Multiload & Fastload interms of Performance?

8 Answers   Cap Gemini, Intel,

how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u

0 Answers  

if collect stats but it show low confidence why?

0 Answers   IBM,

For more Teradata Interview Questions Click Here
Categories