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 composite primary key in sql?

999

How subquery works in sql?

1074

Is primary key a clustered index?

969

Why coalesce is used in sql?

1014

What is trigger point?

1000

Explain how can you save or place your msg in a table?

1029

Mention what are different methods to trace the pl/sql code?

1213

What are the packages in pl sql?

1012

What is difference between ms sql and mysql?

970

What is the plv (pl/vision) package offers?

1054

How do I save a sql query?

1018

explain the advantages and disadvantages of stored procedure? : Sql dba

1014

What is online transaction processing (oltp)?

1018

What does data normalization mean?

972

Explain the order of sql statement execution?

1049