How can u find column name from a table which have max value
in a row.( not max value)

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

544


difference between anonymous blocks and sub-programs.

620


What are the types of queries in sql?

516


What are the possible values that can be stored in a boolean data field?

513


How to find 3rd highest salary of an employee from the employee table in sql?

564






how to convert character strings to dates? : Sql dba

522


Which command is used to delete a trigger?

769


What is the difference between local and global temporary table?

546


How to add new employee details in an employee_details table with the following details

643


tell me about various levels of constraint. : Sql dba

527


What is sql injection vulnerability?

494


What types of commands can be executed in sql*plus?

545


Why do we need a foreign key?

546


Why do we need cursors in pl sql?

516


What is rownum and rowid?

563