Last record of every month in SQL

Question

how to find last record of every month in sql

Answer 1

Actually, I was reluctant to respond, you didn't even mention your Table name, nor did you explain your table structure, but anyway, you might want to try this:

SELECT * FROM yourTable WHERE recordSaveDate = MAX(recordSaveDate);

*Note: recordSaveDate is a date, or datetime field.

Hth, cmiiw