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

Which nosql database is best?

915

How to load data with sql*loader?

993

Advantages and disadvantages of stored procedure?

1057

Why we use stored procedure instead of query?

948

Can we connect to postgresql using sql developer?

932

What is data profiling in sql?

1015

what is bcp? When does it used? : Sql dba

932

How do you use collections in procedure to return the resultset?

2179

what does myisamchk do? : Sql dba

961

How much ram can sql express use?

927

List the various privileges that a user can grant to another user?

987

Explain what is rdbms?

990

What is sap sql anywhere?

966

Can 2 queries be executed simultaneously in a distributed database system?

1077

How much does sql certification cost?

1014