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 dialect in sql?

520


Write a query to display the current date in sql?

505


What is the difference between microsoft access and sql server?

522


which types of join is used in sql widely? : Sql dba

535


Explain how exception handling is done in advance pl/sql?

546






What is pl/sql table? Why it is used?

551


What are different methods to trace the pl/sql code?

531


What packages(if any) has oracle provided for use by developers?

5012


What is the trigger in sql?

528


What does stand for in sql?

513


How do I save a stored procedure?

513


How do I send sql query results to excel?

569


what is collation? : Sql dba

604


What is the process of debugging?

543


What is the maximum number of triggers, you can apply on a single table?

536