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

4 Answers
7261 Views
I also Faced
E-Mail Answers

Answer Posted / suresh ramsng

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

Is This Answer Correct ?

2 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How do you create a unique index?

1031

What is string join?

962

Mention what are different methods to trace the pl/sql code?

1173

What is rowtype?

997

Explain aggregate functions are available there in sql?

977

Which data type is a composite type?

973

what are the drivers in mysql? : Sql dba

1006

Does view contain data?

1014

How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?

1116

how to include numeric values in sql statements? : Sql dba

1082

How do I create a sql script?

1083

what is the bond code in materialized view?

2980

what are the nonstandard string types? : Sql dba

1119

What is dynamic query?

957

what is the command line end user interface - mysql? : Sql dba

963