<div>
that looks like:<br />

<pre><code id="code-166902">SELECT Column1, MAX(Column2), MAX(Column3), MAX(Column4) FROM TABLE_A GROUP BY Column1 
but you might not have told the entire story?
</code></pre>
</div>


that looks like:


SELECT Column1, MAX(Column2), MAX(Column3), MAX(Column4) FROM TABLE_A GROUP BY Column1 
but you might not have told the entire story?


<div>
angell, thanks for the solution but that is not what I am looking for. I want the max of 3 columns(column2, column3, column4)<br />
something like this max(column2, column3, column4).<br />
<br />
Thanks.
</div>


angell, thanks for the solution but that is not what I am looking for. I want the max of 3 columns(column2, column3, column4)
something like this max(column2, column3, column4).

Thanks.

<div>
reference:<br />
<a href="http://techonthenet.com/oracle/functions/greatest.php" rel="ugc">http://techonthenet.com/oracle/functions/greatest.php</a>
</div>


reference:
http://techonthenet.com/oracle/functions/greatest.php [http://techonthenet.com/oracle/functions/greatest.php]

<div>
thanks angellll, it worked great.
</div>


<div>
<div class="content wysiwyg-content">
Hello All,<br />
<br />
I have a table with 4 columns.<br />
<br />
Table A<br />
Column1, Column2, COlumn3, Column4<br />
<br />
I want to get Column1 and the max value of Column2, Column3, COlumn4. Can some one please provide me with an example on how to do this.<br />
<br />
I am writing this query against Oracle database.<br />
<br />
Any help is appreciated.<br />
<br />
Thanks,<br />
SRM.
</div>
</div>


Hello All,

I have a table with 4 columns.

Table A
Column1, Column2, COlumn3, Column4

I want to get Column1 and the max value of Column2, Column3, COlumn4. Can some one please provide me with an example on how to do this.

I am writing this query against Oracle database.

Any help is appreciated.

Thanks,
SRM.

Getting max value in oracle

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.