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
What are sql injection vulnerabilities?
What is loop in pl sql?
What are the two types of cursors in pl sql?
What is type and rowtype in pl sql?
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...
Is big data nosql?
Is hadoop a nosql?
What do you mean by stored procedures? How do we use it?
Is sql similar to python?
What is the importance of sqlcode and sqlerrm?
What is the current version of sql?
What is null in pl/sql?
Explain the difference between triggers and constraints?
what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba
How to add a column ‘salary’ to a table employee_details?