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 is the use of double ampersand (&&) in sql queries?

1178

What is implicit cursor in pl sql?

1097

how to convert numeric values to character strings? : Sql dba

1112

write an sql query to find names of employee start with 'a'? : Sql dba

1031

What is a stored procedure in sql with example?

1137

How do you add a column to a table?

1062

What is meant by cursor in sql?

1007

how to drop an existing table in mysql? : Sql dba

1051

Should I use mbr or gpt?

1030

Why function is used in sql?

952

what are the advantages of mysql in comparison to oracle? : Sql dba

1007

How to pipe multiline string to isql?

1010

How do you break a loop in pl sql?

1055

What does the acronym acid stand for in database management?

1034

How can a function retun more than one value in oracle with proper example?

1080