create table aa_test( a number, b number, c number) ; select g

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

Question Posted / ganesh

Answer Posted / ganesh

create table aa_test(
a number,
b number,
c number)
;

select greatest(a,b,c) from aa_test where a=99 ;

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Can we commit in trigger?

630

What found sql?

604

What is a unique key?

683

what is blob? : Sql dba

650

Does inner join remove duplicates?

622

What is the difference between partitioning and sharding?

619

what is the difference between ereg_replace() and eregi_replace()? : Sql dba

650

What is varchar data type in sql?

606

What is sql in oracle?

703

How can I change database name in sql?

611

what are date and time data types in mysql? : Sql dba

592

what is sql server agent? : Sql dba

686

What is record data type?

608

What is t-sql? : Transact sql

623

What are the benefits of pl/sql packages?

639