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 is the difference between inner and outer join? Explain with example. : Sql dba

1036

how can we submit a form without a submit button? : Sql dba

999

what is the difference between truncate and drop statements? : Sql dba

1140

How many columns should be in an index?

968

what is a trigger in mysql? Define different types of trigger. : Sql dba

1080

What is natural join in sql?

1007

What is cursor explain with example?

995

Why do we use %rowtype & %type in plsql?

1058

what is bdb (berkeleydb)? : Sql dba

1042

How do I find sql profiler?

951

What is cross join example?

1017

What is the current version of sql?

1032

What is group by in sql?

1092

Can we join tables without foreign key?

968

What is meant by temporal data?

980