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...

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)

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


Please Help Members By Posting Answers For Below Questions

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

2184


What are the available join types in teradata?

1073


What is the purpose of indexes?

1080


If RDBMS is halted what will you do ?

2171


What is dimensional modeling?

1090


What is the syntax for case when statement?

1151


tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you

837


how many modules are there in telecome domain?how to explain the architecture?

2018


Explain the term 'columns' related to relational database management system?

1075


If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?

2482


Explain and compare pros and cons of start schemas?

1073


What can be achieved by using the teradata rdbms?

1044


What is teradata and why it is used?

1102


What is meant by a Parsing Engine?

1191


How can you track login parameters of users in teradata?

1198