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

Is truncate ddl or dml?

538

What does sign mean sql?

561

What is use of package in pl sql?

527

How many types of sql are there?

518

What is group function in sql?

523

What is mdf ldf and ndf?

554

what is the difference between truncate and delete statement? : Transact sql

535

Explain aggregate functions are available there in sql?

528

What are the two types of periodical indexes?

499

Explain the methods used to protect source code of pl/sql.

535

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

532

Where the sql database files are stored?

477

What is a table?

562

What is a primary key sql?

557

What are the different types of sql commands?

591