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 the types of functions in sql?

1068

What is primary key and unique key?

1167

Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?

1210

How can you get sql*loader to commit only at the end of the load file? : aql loader

1062

What are the two characteristics of a primary key?

1033

name 3 ways to get an accurate count of the number of records in a table? : Sql dba

1116

What is the difference between stored procedure and view?

1067

What is pivot in sql?

974

can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba

1049

What is cursor explain with example?

1032

Can a table have no primary key?

1113

what is the difference between $message and $$message? : Sql dba

1042

how many sql ddl commands are supported by 'mysql'? : Sql dba

1067

Is sql a oracle?

1022

explain the advantages and disadvantages of stored procedure? : Sql dba

1067