How can u find column name from a table which have max value
in a row.( not max value)
Answer Posted / mahalakshmi s
select case when col1>col2 then 'col1' else 'col2' end, greatest(col1,col2) end from table_name;
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is online transaction processing (oltp)? : Sql dba
What are analytic functions in sql?
What is implicit cursor in pl sql?
Which command is used to delete a trigger?
What is cascade in sql?
Why query optimization is needed?
Why do we create views in sql?
How does sql store data?
How do you declare a user-defined exception?
How do I truncate a word?
how to get @@error and @@rowcount at the same time? : Sql dba
What is a dirty read sql?
What is data definition language?
Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?
What is coalesce in sql?