Author Closing Comment
SELECT ID, Insurance, yt_max.max_date, yt.PayDate
FROM YourTable yt
SELECT ID, Insurance, Max(Date) as max_date
GROUP BY id, Insurance) yt_max ON yt.ID = yt_max.ID AND yt.date = yt_max.max_date
Open in new window
SELECT ID, Insurance, Amount,PayDate
SELECT ID, Insurance, Amount,PayDate, row_number() over(partition by ID order by PayDate DESC) as rn
) as derived
WHERE rn = 1
This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud
If you are experiencing a similar issue, please ask a related question
Join the community of 500,000 technology professionals and ask your questions.
Join & Ask a Question
Join our community for more solutions or to ask questions.
For immediate help use Live now!