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 compilation error in pl sql?

504

What is mdf ldf and ndf?

558

how is exception handling handled in mysql? : Sql dba

549

What is pl sql commands?

555

what is the difference between sql and t-sql? : Transact sql

597

How do I quit sql?

495

Why is theta join required?

662

What are operators available in sql?

585

What is a sql statement?

529

What is the usage of the distinct keyword?

682

Explain alias in sql?

582

What is the difference between rollback and rollback to statements?

581

What are the most important characteristics of pl/sql?

573

What is pessimistic concurrency control? : Transact sql

584

how do you know if your mysql server is alive? : Sql dba

592