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 trigger and stored procedure in sql?

559


What is the usage of nvl function?

599


Why join is faster than subquery?

603


What is the difference between sql, mysql and sql server?

533


Which one is better sql or oracle?

504






What is localdb mssqllocaldb?

623


Can a foreign key have a different name?

515


what happens if null values are involved in expressions? : Sql dba

569


What is the usage of when clause in trigger?

571


what is datawarehouse? : Sql dba

572


What are sql triggers used for?

515


What is the maximum number of rows in sql table?

551


how can we know the number of days between two given dates using mysql? : Sql dba

549


which operator is used in query for pattern matching? : Sql dba

547


What are all ddl commands?

551