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 difference between stored procedure and view?

963

Which is faster joins or subqueries?

930

What is difference between inner join and cross join?

909

Which certification is best for sql?

938

Explain locks? : Transact sql

951

What is string join?

932

What can I use instead of union in sql?

903

Is left join inner or outer by default?

973

Is sql pronounced sequel or sql?

1213

Why do we need view in sql?

932

what is bdb (berkeleydb)? : Sql dba

974

What are the advantages of sql? Explain

1051

What is substitution variable in pl sql?

979

Is sql sequential or random?

981

What is nvarchar max in sql?

959