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 / 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 can you know that statistics should be updated?
What are inbuilt functions in sql?
explain the delete statements in sql
Is sqlite thread safe?
How delete all data from all tables in sql?
What are different sql data types?
How do I turn a list into a table?
What is the requirement of self-join?
What is dml with example?
What is normalization in sql?
Why are indexes and views important to an organization?
What is row_number () in sql?
What is audit logout in sql profiler?
Define join and name different types of joins?
what is 'mysqladmin' in mysql? : Sql dba