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

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,

Fast Load Script is failed and error tables are available then how do you restart?

3 Answers   TCS,

How does hashing happens in teradata?

0 Answers  

Explain teradata utilities. What is multiload, fast load, tpump?

0 Answers  

can I use “drop” statement in the utility “fload”?

2 Answers   Accenture, CTS, NTT Data,

What are the string manipulation operators and functions associated with teradata?

0 Answers  

one table have input no name 10 rao 20 siva 30 srinu 10 rao i want to ouput like this way no name 20 siva 30 srinu 10 rao how it posible in only sql server query?not oracle?

3 Answers   IBM,

How can we check the version of Teradata that we are using currently?

0 Answers  

What is the use of fallback?

0 Answers  

What can be achieved by using the teradata rdbms?

0 Answers  

In BTEQ, how are the session-mode parameters being set?

0 Answers  

Describe the set operators in teradata.

0 Answers  

For more Teradata Interview Questions Click Here
Categories