select A,B,greatest(A,B) output from <tablename>

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 / suresh ramsng

Answer Posted / suresh ramsng

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are local and global Indexes and where they are useful.

1377

Can a select statement fire a trigger?

1096

What does cursor do in sql?

969

How do you explain an index number?

1021

What is substitution variable?

1000

What is posting?

990

what are the t string functions available in tsql? : Transact sql

944

explain about mysql and its features. : Sql dba

968

What is the location of pre_defined_functions.

1110

How can we debug in PL/SQL?

1090

What is the max nvarchar size?

897

What is exception? What are the types of exceptions?

1030

what is clause? : Sql dba

1002

What is sqlcontext?

985

How to display Row Number with Records in Oracle SQL Plus?

990