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

Hi Frnds this que is recently asked at IBM there are two rows like aa6588fhfhf,gru282vbvv. Question is howcan we retrive the first number from two rows. Can any one help thanks in advance

5 Answers   IBM,

How to view every column and the columns contained in indexes in teradata?

0 Answers  

In the Primary Index, what is the score of AMPs that are actively involved?

0 Answers  

how do you manage the production space. what are the proactive methods you can take ?

0 Answers  

what is single value and Multivalue ?

1 Answers   IBM, Wipro,

What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?

0 Answers  

Differentiate database data and data warehouse data?

0 Answers  

Describe the set operators in teradata.

0 Answers  

What is the Maximum number of volatile tables that can be created?

4 Answers   Mphasis,

what is the difference between filter and router transmissions

2 Answers  

why should we go Teradata over Oracle,what is the main differences?

4 Answers   TCS,

What are different table types used in teradata?

0 Answers  

For more Teradata Interview Questions Click Here
Categories