title: I want to select a query which would give me a Unique dates and Max(value) within the multiple dates rows
body: <p>I want to select a unique dates from multiple rows and the rows having max(value) from another column.</p>
  
  <p>SQL Table</p>
  
  <pre><code>DateTime        Value
  01-06-2019  100
  01-06-2019  200
  02-06-2019  300
  03-06-2019  400
  04-06-2019  1000
  </code></pre>
  
  <p>Result I want </p>
  
  <pre><code>Jun-01  200
  Jun-02  400
  Jun-03  1000
  
  
  SELECT tt.*
  FROM [dbo].[device_Flow_Data_Json] tt
  INNER JOIN
      (SELECT Created_date, MAX(Instant_Flow) AS Instant_Flow
      FROM [dbo].[device_Flow_Data_Json] 
      GROUP BY Created_date) groupedtt 
  ON tt.Created_date = groupedtt.Created_date 
  AND tt.Instant_Flow = groupedtt.Instant_Flow
   where groupedtt.Created_date between '2019-07-01 14:09:36.040' and '2019-07-11 14:09:36.040'
  </code></pre>
  
  <p>I am getting a result which is having all rows</p>