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

What is the most restrictive isolation level? : Transact sql

1085

How do I send sql query results to excel?

1067

How do I start pl sql?

950

what is a foreign key ? : Sql dba

1084

what is the command used to fetch first 5 characters of the string? : Sql dba

1638

what is sql in mysql? : Sql dba

1197

How many types of primary keys are there?

1040

Is natural join and inner join same?

929

how tsql statements can be written and submitted to the database engine? : Transact sql

995

Is it possible to sort a column using a column alias?

1049

What do you know by pl/sql cursors?

1106

Is sql developer case sensitive?

1001

What are the parts of a basic sql query?

967

What are the limitations of sql express?

1071

What are the different types of joins in sql?

1792