Forum Discussion
lcasey
7 years agoPost Prodigy
Create new Table from Last record
Hello, Is there a way to grab only the LAST record for a bunch of records based on the latest date? In SQL server it is super east and extreemly fast. I woudl simply select * from all rows with M...
- 7 years ago
lcasey
7 years agoPost Prodigy
Hello,
I noticed that there are duplicates in the new table that was created. Do you know why some records are returned more than one time?
lcasey
7 years agoPost Prodigy
I see why the duplicates are there. On the event Date, sometimes there are multiple records with the same exact date causing the table to load multiple records for a company.
I will need to modify the dates to be unique...:) Thanks again!