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 are the most important characteristics of pl/sql?

1135

Explain the commit statement.

1141

What is graph sql?

974

What are the ways on commenting in a pl/sql code?

1115

What are the sql commands?

1139

Can instead of triggers be used to fire once for each statement on a view?

950

How can we avoid duplicating records in a query?

959

Does pl sql work in mysql?

953

Define commit, rollback and savepoint?

1016

what is index? : Sql dba

990

Could you please provide oca (oracle 10g) dumps for my certification ?

5127

What is scalar function?

1034

how to enter binary numbers in sql statements? : Sql dba

953

How does sql*loader handles newline characters in a record? : aql loader

1026

Can you have more than one trigger on a table?

986