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

Can we collect statistics on multiple columns?

0 Answers  

Describe primary index in teradata?

0 Answers  

What are the advantages of teradata?

0 Answers  

What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?

0 Answers  

how to delete duplicate records in multi set table without using any tables

2 Answers   Accenture, Nest, South Nests Software Solution, Spiro Solutions,

Hello all, There is a table with 4 columns in that 3 columns has been already loaded with 5 million records.4th column is empty,Now I have got 5 million records data which has to be loaded into 4th column.How can I load this data fastly in to the 4th column with out using update

5 Answers   CTS, TCS,

can i call router is a passive transformation

2 Answers  

Why Multiload and Fastload does not supports SI,JI,RI and TRIGGERS?

4 Answers  

What are the joins in teradata?

0 Answers  

what is meant by Hot amp?

2 Answers   IBM, Satyam,

Please tell me a query to find the Primary key,Foreign key,primary Index,PPI for the Database?

5 Answers  

What is TPD?

0 Answers  

For more Teradata Interview Questions Click Here
Categories