select greatest(cola,colb) from tblname;

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 / phani kumar

Answer Posted / phani kumar

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

list out some tools through which we can draw e-r diagrams for mysql. : Sql dba

965

explain normalization concept? : Sql dba

1043

Write a query to display the current date in sql?

1018

What is the difference between microsoft access and sql server?

1051

Can cursors be part of a trigger body?

1636

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

1058

Is subquery faster than join?

1009

What is the difference between drop and truncate commands?

1055

How many types of triggers are there in pl sql?

1063

What is a behavioral trigger?

970

Is big data nosql?

942

What do you understand by pl/sql packages?

1058

What is the max nvarchar size?

960

What is the use of index in hive?

1001

How to return multiple rows from the stored procedure?

966