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.

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

What is the difference between inner join and left join?

732


What is the starting oracle error number?

751


Define SQL and state the differences between SQL and other conventional programming Languages?

870


what are tables and fields? : Sql dba

766


What are sql injection vulnerabilities?

690






How do I count rows in sql query?

688


What do you think about pl/sql?

699


What is the use of function in sql?

727


Who is the owner of mysql database?

732


Is merge a dml statement?

726


What is the use of double ampersand (&&) in sql queries? Give an example

808


what is the use of set statement in tsql? : Transact sql

737


Why is the cursor important?

729


What is cartesian join in sql?

742


Which nosql database is best?

679