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 do you know by pl/sql cursors?

1106

What is auto increment in sql?

1123

Is sql between inclusive?

1134

What is information schema in sql?

1071

What is the difference between the sql*loader and import utilities? : aql loader

1043

What is a stored procedure in sql with example?

1132

How to pipe multiline string to isql?

1007

Explain table and field in sql?

1063

What is trigger price?

990

What are analytical functions in sql?

1030

What is raid? How does it help storage of databases?

1087

Why do we need unique key in a table?

958

What are sql functions? Describe the different types of sql functions?

1143

Explain the difference between rename and alias?

1011

What are the various restrictions imposed on view in terms of dml?

966