Donate

SQL Retrieve Or Count Record On A Previous Date In MySQL

Here's a simple demonstration of sql in MySQL where you can retrieve a record from a previous date.
  select sum(data_gathered) as data_gatherer,   
      name from tblctivity  
       where name like '%prgGatherer1.xml%'  
         and (date(rec_date) = (CURDATE() - 1));

Comments

Donate

Popular Posts From This Blog

WPF CRUD Application Using DataGrid, MVVM Pattern, Entity Framework, And C#.NET

How To Insert Or Add Emojis In Microsoft Teams Status Message

Bootstrap Modal In ASP.NET MVC With CRUD Operations