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 Difference Between Unique and Primary Key Constraints?

1152

Do ddl statements need commit?

1020

What is a call statement? Explain with an example.

1068

Does access use sql?

1096

How to check if a column is nullable before setting to nullable?

1179

How to avoid using cursors? What to use instead of cursor and in what cases to do so?

1243

How to process query result in pl/sql?

1197

What is the difference between an inner and outer join?

1055

describe transaction-safe table types in mysql : sql dba

1052

How is indexing done in search engines?

1021

how many triggers are allowed in mysql table? : Sql dba

1102

Is sql a programming?

1025

Can we insert data into materialized view?

989

is mysql query is case sensitive? : Sql dba

1162

How to display the current date in sql?

1128