select a,b, CASE WHEN (a>b) THEN a ELSE b END output from a

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 / apoorva garg

Answer Posted / apoorva garg

select a,b,
CASE WHEN (a>b) THEN a
ELSE b
END output
from a

Is This Answer Correct ?

9 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to process query result in pl/sql?

1198

What is the difference between sql, mysql and sql server?

1174

Why do we need pl sql?

1037

What is the purpose of cursors in pl/sql?

1200

What is a delimiter in sas?

1124

what are properties of a transaction? : Sql dba

1134

What is difference between sql and oracle?

1191

what is 'mysqladmin' in mysql? : Sql dba

1073

What is user in sql?

1074

What is file based approach?

998

Why sql query is slow?

1041

What are the advantages of indexing?

1025

How do I find sql profiler?

990

what are the differences among rownum, rank and dense_rank? : Sql dba

1085

what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

1006