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

Hi All,
I have a table with 3 fields like id,mark1,mark2 and I would
like to update a mark3 field that would calculate the max
for each record (so the max value of the 2 fields) in
Teradata
ID Mark1 Mark2 Mark3
1 10 20
2 20 30
3 40 10
4 50 50
I Have to write a update statement Mark3 with max value of
mark1,mark2 fields…like bellow
ID Mark1 Mark2 Mark3
1 10 20 20
2 20 30 30
3 40 10 40
4 50 50 50
Please any one help me ....Thq

Question Posted / nbk

Answers were Sorted based on User's Feedback



Hi All, I have a table with 3 fields like id,mark1,mark2 and I would like to update a mark3 field..

Answer / subbu

Hi NBK,

You can use the below UPD query to update the mark3 field
with maximum marks of Mark1 or Mark2 fields.

Update db_name.Tab_name
set mark3 = case
when mark1>mark2
then mark1
else mark2
end

Is This Answer Correct ?    13 Yes 0 No

Hi All, I have a table with 3 fields like id,mark1,mark2 and I would like to update a mark3 field..

Answer / tdguy

Above answer is correct. Update statement would be the best
option (with case).

Update tablename
set mark3 = case when mark1>mark2
then mark1 else mark2 end;

Is This Answer Correct ?    3 Yes 0 No

Hi All, I have a table with 3 fields like id,mark1,mark2 and I would like to update a mark3 field..

Answer / rajesh

I didnt understand ur question,give me correct question and
excat o/p u wanted ,send example o/p what u wanted

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Teradata Interview Questions

what is meant by Hot amp?

2 Answers   IBM, Satyam,

Find 2 highest sal from each dept who have completed 5 year in org

0 Answers   Wipro,

Hi All, can anyone tell me how many types of Skew exists? whats the difference between amp skew,data skew,cpu skew, io skew, delta amp cpu ?

2 Answers  

What is the difference between SI and JI?

2 Answers  

What is node? How many nodes and amps used in your previous project?

0 Answers  

What do you mean by teradata sql assistant?

0 Answers  

What is basic teradata query language?

0 Answers  

What is the difference between teradata and basic rdbms?

0 Answers  

Can you fastexport a field, which is primary key by putting equality on that key?

0 Answers  

can we join volatile table with general table an global temporary table with general table ?

4 Answers   IBM,

hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. yedu my email-id: jakkayedukondalu@gmail.com@gmail.com

0 Answers  

How many tables can you join in v2r5?

0 Answers  

For more Teradata Interview Questions Click Here
Categories