<div>
SELECT GREATEST(field1,fiedl2, field3, field4) from yourtable
</div>


SELECT GREATEST(field1,fiedl2, field3, field4) from yourtable

<div>
put semi colon after:<br />
<br />

<pre><code id="code-20-40238896-1">SELECT GREATEST(field1,fiedl2, field3, field4) from yourtable;</code></pre>
</div>


put semi colon after:



SELECT GREATEST(field1,fiedl2, field3, field4) from yourtable;

<div>
I need the user associated with the Greatest value
</div>


I need the user associated with the Greatest value

<div>
Try this and see if it solves your problem.<br />
<br />

<pre><code id="code-20-40238963-1">SELECT t1.user1,t1.user2,t1.user3,t1.user4
FROM yourtable t1
INNER JOIN
(
    SELECT GREATEST(field1,field2,fiel3,fiel4)
    FROM yourtable t2
) t2 ON t1.ID=t2.ID</code></pre>
 <br />
<br />
yourtable t1 and t2 are same table.
</div>


Try this and see if it solves your problem.



SELECT t1.user1,t1.user2,t1.user3,t1.user4
FROM yourtable t1
INNER JOIN
(
    SELECT GREATEST(field1,field2,fiel3,fiel4)
    FROM yourtable t2
) t2 ON t1.ID=t2.ID



yourtable t1 and t2 are same table.

<div>
Sorry,. I need the &nbsp;GREATEST VALUE and USER<br />
So it returns<br />
<br />
8/4/2014 &nbsp; &nbsp; &nbsp; Mike<br />
<br />
<br />
thx
</div>


Sorry,. I need the  GREATEST VALUE and USER
So it returns

8/4/2014       Mike


thx

<div>
<div class="content wysiwyg-content">
Hi.<br />
I have data that looks like this: &nbsp;I need to return the GREATEST date (most current) along with the USER associated with the date. So I want to return 2 fields &nbsp; DATE &amp;&nbsp;USER<br />
<br />
FIELD1 &nbsp; &nbsp; USER1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FIELD2 &nbsp; &nbsp; &nbsp; &nbsp; USER2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FIELD3 &nbsp; &nbsp; &nbsp; &nbsp; USER3<br />
1/1/2001 &nbsp; &nbsp;BOB &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1/4/2013 &nbsp; &nbsp; &nbsp; JANE &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;8/4/2014 &nbsp; &nbsp; &nbsp; MIKE<br />
<br />
Should return<br />
8/4/2014 &nbsp; &nbsp; &nbsp; Mike
</div>
</div>


Hi.
I have data that looks like this:  I need to return the GREATEST date (most current) along with the USER associated with the date. So I want to return 2 fields   DATE & USER

FIELD1     USER1           FIELD2         USER2           FIELD3         USER3
1/1/2001    BOB           1/4/2013       JANE            8/4/2014       MIKE

Should return
8/4/2014       Mike

Help with Query using GREATEST

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.