select greatest(nvl(cola,0),nvl(colb,0)) from tablename

column A column b | output
10 7 | 10
5 8 | 8
7 -9 | 7
3 5 | 5
0 6 | 6

Write a sql query to print such output.

Question Posted / satish tadepalli

Answer Posted / satish tadepalli

Is This Answer Correct ?

6 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What normalization means?

971

Is sql free?

955

what is the difference between undefined value and null value? : Sql dba

1098

what are sequences

1741

What is difference between hql and sql?

1072

Explain the commit statement.

1153

Should I use mbr or gpt?

1024

Define select, insert, create, delete, update, drop keywords

1044

What is bind reference and how can it be created?

1016

What is #table in sql?

1092

what is data integrity? : Sql dba

1036

What is faster join or subquery?

1009

How do you write an index?

962

What is the mutating table and constraining table?

1024

what is the difference between myisam static and myisam dynamic? : Sql dba

1059