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 the difference between an inner and outer join?

541

What is partition in sql query?

520

What is sql profiler in oracle?

568

Write a sql select query that only returns each name only once from a table?

572

Explain the working of primary key?

614

What is sqlservr exe?

482

Define the select into statement.

576

what is a constraint? Tell me about its various levels. : Sql dba

564

what is a trigger in mysql? Define different types of trigger. : Sql dba

556

What are properties of the transaction?

562

How many types of triggers exist in pl/sql?

572

What is coalesce sql?

518

What are the string functions in sql?

530

Why we use sql profiler?

563

Inline the values in PL/SQL, what does it mean.?

634