Is There Any Way I Can Select The Latest Record In The Database And Categorize It Per Month?

WITH OrderedData As
(
    SELECT
        Date,
        NetIncome,
        OtherColumns,
        
        ROW_NUMBER() OVER 
        (
            PARTITION BY 
                -- Generate a new sequence for each month:
                DateAdd(day, 1 - Day(Date), Date) 
                
            ORDER BY 
                -- Order the sequence by the date in descending order:
                Date DESC
        ) As RN
    FROM
        YourTable
)
SELECT
    Date,
    NetIncome,
    OtherColumns
FROM
    OrderedData
WHERE
    -- Take the record for the last date in each month:
    RN = 1
;

SELECT 
  [Year] = DATEPART(Year, EntryDate), 
  [Month] = DATEPART(Month, EntryDate), 
  [Date] = MAX(DATEPART(Date, EntryDate)) 
FROM 
  MyTable 
GROUP BY 
  DATEPART(Year, EntryDate), 
  DATEPART(Month, EntryDate)

SELECT
  mt.EntryDate, mt.Amount
FROM
  MyTable mt
    INNER JOIN
      (
        SELECT 
          [Year] = DATEPART(Year, EntryDate), 
          [Month] = DATEPART(Month, EntryDate), 
          [Date] = MAX(DATEPART(Date, EntryDate)) 
        FROM 
          MyTable 
        GROUP BY 
          DATEPART(Year, EntryDate), 
          DATEPART(Month, EntryDate)
      ) t
     ON
       DATEPART(Year, mt.EntryDate) = t.[Year] AND
       DATEPART(Month, mt.EntryDate) = t.[Month] AND
       DATEPART(Date, mt.EntryDate) = t.[Date]
ORDER BY
  mt.EntryDate DESC

select * from tablename t1
inner join
(
   select distinct max(date_column) date_column from tablename
   group by year(date_column), month(date_column)

)  t2
on t1.date_column=t2.date_column order by t1.date_column asc