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 is view? Can we update view

1440

Show code of a cursor for loop.

1055

Is truncate ddl or dml?

991

How do you explain an index?

1282

Is mariadb nosql?

1041

What is rename command in sql?

1036

What is a primary key example?

959

how would you get the current date in mysql? : Sql dba

967

How do I run a pl sql program?

1130

What is constant in pl sql?

1023

What is compound trigger?

1038

what is self join and what is the requirement of self join? : Sql dba

1145

Is sqlite free?

975

what are all types of user defined functions? : Sql dba

1042

What is cursor and its types?

1073