Answer Detail: RE: write a query to update third column such that

GeekInterview.com > Interview Questions > Oracle > SQL

Print |

Question: write a query to update third column such that

Answer: There is a table having the following columns :-
student id marks1 marks2 maxmarks
1 10 20 20
2 25 30 30
3 30 10 30
4 35 25 35
5 20 40 40

write a query to update column maxmarks such that maxmarks column contains
whatever be the greater value among marks1 and marks2 columns ( as shown in table ).

September 09, 2008 04:54:29	#5
tripathi.atul	Member Since: September 2008 Total Comments: 4
RE: write a query to update third column such that
Instead of -1 positive 1 should be there in the decode. Another way can be to use the greatest sql function. update aa set maxmarks= greatest(marks1,marks2)

Back To Question