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

Can we create view in stored procedure?

955

How to set up sql*plus output format in oracle?

1026

How to read xml file in oracle pl sql?

905

What are keys in sql?

992

Is it possible to include an insert statement on the same table to which the trigger is assigned?

1008

What is the best sql course?

976

what does it mean to have quoted_identifier on? : Sql dba

1139

What is sql in java?

1070

Is sql database free?

962

what is the difference between sql and t-sql? : Transact sql

1082

What is the execution plan in sql?

1014

how to select first 5 records from a table? : Sql dba

970

What is function and procedure in pl sql?

1033

List the ways to get the count of records in a table?

900

How do I find sql profiler?

932