select greatest(cola,colb) from tblname;

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.

Question Posted / phani kumar

4 Answers
7266 Views
I also Faced
E-Mail Answers

Answer Posted / phani kumar

select greatest(cola,colb) from tblname;

Is This Answer Correct ?

2 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Which data dictionary views have the information on the triggers that are available in the database?

1225

Can a foreign key be null?

1068

What is dml with example?

1064

What are the two types of exceptions in pl/sql?

1026

what is the difference between a web-garden and a web-farm? : Sql dba

1062

Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?

1010

Why use subqueries instead of joins?

1066

What is pl sql script?

1010

Why do we need view in sql?

968

What is cursor in pl sql with examples?

1010

What are the types of variables use in pl sql?

1024

Mention what are the benefits of pl/sql packages?

1058

What is bind variable in pl sql?

1027

What is sql profiling in oracle?

1040

What are the main features of cursor?

1065