title: How to select the latest daily data from a table?
body: <p>I have a table for Logging. In this table there is a column type datetime. how can i select the latest daily records? Could someon please help me?</p>
  
  <p>Thanks!</p>
  
  <p><strong>Update!</strong>
  In this table there are the following columns:
  InventoryNr, SerialNr, Oldusername, OlduserId, oldcostcenter, newusername, newuserid, newcostcenter, changedby, changedate.</p>
  
  <p>Here the devices will be inserted automatically. So if a monitor is detected on a computer, it will be recorded in this table. However if i move the monitor to another pc it will be recorded once more. But in some cases a monitor can "jump" between two PCs.  And with PC's it is the same. If a PC's owner has been changed, then it will be inserted here automatically etc. So if i run this query, i need only the latest rows from a device, from that current day. Hope you can understand now what i meant. </p>
  
  <p>Thanks!</p>