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

How to pronounce postgresql?

1032

How do I create an index in word?

1009

Is sqlite thread safe?

1031

What are the methods of filing?

918

In what condition is it good to disable a trigger?

995

What are the advantages of pl sql over sql?

1010

Mention what is the plv (pl/vision) package offers?

1090

What is a crud api?

938

What is query execution plan in sql?

1164

What is #table in sql?

1068

Why is a trigger used?

925

Does sql view stored data?

936

what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba

1020

What are the steps for performance tuning.

1315

Is sqlite good enough for production?

981