'How to nearest date in the future to between today with sql (mysql)

I want to see the report date with the nearest future date. I want it to be a single record based on implementation id. Today 02-18-2022

SELECT   *
   FROM     document_reports
   WHERE    reportDate >= now() AND reportDate in 
   (SELECT MIN(reportDate) 
   FROM document_reports 
   WHERE reportDate >= NOW()
   group by implementation_id )
   
   group by implementation_id
   order by reportDate

You can check the tables in the below

You can check the tables in the below

Please help me? Where did I make mistake?

mysqlsqllaravel


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions