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

Why is normalization important?

1005

How consistent is the view of the data between and within multiple sessions, transactions or statements ?

2207

What is clause in sql?

1092

Is oracel sql developer written in java?

1088

What does bitemporal mean?

1046

What sql database should I use?

1122

What is trigger with example?

1065

Is sql database free?

959

What does count (*) do in sql?

981

Explain scalar functions in sql?

1044

How do I create a memory optimized filegroup?

944

what are the types of subquery? : Sql dba

1087

how to fetch common records from two tables? : Sql dba

1155

What are expressions?

990

What is the difference between a primary key and a clustered index?

968