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

What is difference between left and right outer join?

1036

What does trigger mean in slang?

1123

Is pl sql useful?

1037

How can one get sql*loader to commit only at the end of the load file? : aql loader

1114

Can we join tables without foreign key?

1005

How do I view stored procedures?

1023

What is audit logout in sql profiler?

1073

What is the difference between inner join and left join?

1036

Can we call dml statement in function?

1096

Is oracle and sql same?

1076

What are types of joins?

1026

What are the different ddl commands in sql?

1251

What is server name sql?

1203

what is not null constraint? : Sql dba

1076

what does myisamchk do? : Sql dba

1079