user greatedt function. Ex select greatest(sal,bonus) from emp where emp

How can u find column name from a table which have max value
in a row.( not max value)

Question Posted / prashanth

Answer Posted / prashanth

user greatedt function.

Ex select greatest(sal,bonus) from emp where emp_id = 1000;

Is This Answer Correct ?

2 Yes

6 No

Please Help Members By Posting Answers For Below Questions

What are procedures used for?

924

What is a sql instance vs database?

1038

What is prepared statement in sql?

998

What is the size of partition table?

992

How can a pl sql block be executed?

891

What is the difference between join and natural join?

883

Explain two easy sql optimizations.

962

What is difference between sql and excel?

1010

What are hotfixes and patches?

889

How do I find duplicates in sql?

879

Does user triggers have entry for trigger with compilation errors?

975

What are two statement types in sql?

1033

What is hibernate and its relation to sql?

1068

How can we implement rollback or commit statement in a trigger?

981

How to connect a sql*plus session to an oracle server?

1081