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 does sql stand for?

1053

What are aggregate and scalar functions?

1083

How to use transactions efficiently : transact sql

1114

Does group by remove duplicates?

1092

How many types of triggers exist in pl/sql?

1129

Is sql a programming?

1024

Can I create table without primary key?

1041

What is a trigger in sql?

1232

how to include comments in sql statements? : Sql dba

999

What are tuples in sql?

1197

What are different types of keys?

1171

What are the subsets of sql?

1194

Why is pl sql used?

1026

What is an index? What are the types of indexes? How many clustered indexes can be created on a table?

1131

What is the difference between numeric and autonumber?

1038