title: Selecting the last entry of each day in a timestamp and corresponding value
body: <p>I have the following table "test", </p>
  
  <p><img src="https://i.stack.imgur.com/T5h8M.jpg" alt="enter image description here"></p>
  
  <p>Let the data in the table be as follows,</p>
  
  <p><img src="https://i.stack.imgur.com/6Il8B.jpg" alt="enter image description here"></p>
  
  <p>Now I want to select last entry (only date not the timestamp) for each day and corresponding value as two columns. one being the date and other being the value.</p>
  
  <p>I am able to fetch  only the date using the following query,</p>
  
  <pre><code>SELECT max( date( date ) ) AS date
  FROM test
  GROUP BY date( date )
  LIMIT 0 , 30 
  </code></pre>
  
  <p>But am not being able to get the corresponding values for those dates.
  How can I do it..? By googling, I came to know that I have to use join to achieve this, but again I couldn't use join without any errors. </p>