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 different between now() and current_date()? : Sql dba

1020

Can pl sql procedure have a return statement?

1030

What are system versioned tables?

1027

what are the authentication modes in sql server? : Sql dba

1061

Explain what is rdbms?

1032

Why query optimization is needed?

922

What are the most important ddl statements in sql?

1114

what are the different type of normalization? : Sql dba

1027

What are the dml statements?

1141

What is the use of function in sql?

1093

Is pl sql a scripting language?

1030

How can I see all tables in sql?

1074

What does t sql mean?

944

What are the types of index in sql?

1069

Are subqueries better than joins?

974