select greatest(cola,colb) from tblname;

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 / phani kumar

Answer Posted / phani kumar

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What does := mean in pl sql?

1046

What is sql rowcount?

1022

What are crud methods?

1036

Is sql a oracle?

981

When is the update_statistics command used?

1120

Is pl sql different from sql?

1001

What is the example of procedure?

928

What are hotfixes and patches?

946

what is the use of set statement in tsql? : Transact sql

1011

What is function and procedure in pl sql?

1046

What is data abstraction in sql?

1032

what is the difference between where clause and having clause? : Sql dba

1000

What are different methods to trace the pl/sql code?

1119

how does a local variable is defined using t-sql? : Transact sql

1018

What are expressions?

1015