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.
- 4 Answers
- 6580 Views
- I also Faced
- E-Mail Answers
Answer Posted / satish tadepalli
select greatest(nvl(cola,0),nvl(colb,0)) from tablename
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
How many types of relationship are there?
What are joins in sql?
How to install oracle sql developer?
What is graph sql?
Why is nosql good?
What are the benefits of triggers?
How do you delete duplicates in sql query using rowid?
What is sqlerrm?
is it possible to pass an object or table to a procedure as an argument?
Explain the significance of the & and && operators in pl sql.
Does sql*plus have a pl/sql engine?
what is sql server agent? : Sql dba
what are all the different types of indexes? : Sql dba
How can one get sql*loader to commit only at the end of the load file? : aql loader
What is the difference between stored procedure and view?
