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 can a function retun more than one value in oracle with proper example?

1072

How many tables can you join in sql?

955

What does the argument [or replace] do?

1075

How many aggregate functions are available there in sql?

979

How is a process of pl/sql compiled?

1154

Is ms sql traffic encrypted?

920

What is the difference between numeric and autonumber?

995

Is record in oracle pl sql?

958

What is the order of sql select?

1041

List and explain the different types of join clauses supported in ansi-standard sql?

1352

What is sqlca in powerbuilder?

1002

Explain the insert into statements in sql?

1003

Is it possible to link two groups inside a cross products after the cross products group has been created?

1002

how can we destroy the session, how can we unset the variable of a session? : Sql dba

997

what is error ora-03113: end-of-file on communication channel?

1157