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
What is trigger and stored procedure in sql?
What is the usage of nvl function?
Why join is faster than subquery?
What is the difference between sql, mysql and sql server?
Which one is better sql or oracle?
What is localdb mssqllocaldb?
Can a foreign key have a different name?
what happens if null values are involved in expressions? : Sql dba
What is the usage of when clause in trigger?
what is datawarehouse? : Sql dba
What are sql triggers used for?
What is the maximum number of rows in sql table?
how can we know the number of days between two given dates using mysql? : Sql dba
which operator is used in query for pattern matching? : Sql dba
What are all ddl commands?