How to get record based on nearest date in SQL

Question

How to get record based on nearest date in SQL

Viewing 2 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply

jcelko212 32090 SSCrazy Eights Points: 9304 More actions · Answer 1

In a set-oriented language you return the whole set of values that are temporally equal toMight wan the min(date diff) over(patition by account) .

Look up Dr. Codd's T-Join for something like this. I did an article on this https://www.sqlservercentral.com/articles/celkos-sql-stumper-the-class-scheduling-problem

Please post DDL and follow ANSI/ISO standards when asking for help.

kaj SSCommitted Points: 1616 More actions · Answer 2

jcelko212 32090 wrote:

In a set-oriented language you return the whole set of values that are temporally equal toMight wan the min(date diff) over(patition by account) .
Look up Dr. Codd's T-Join for something like this. I did an article on this https://www.sqlservercentral.com/articles/celkos-sql-stumper-the-class-scheduling-problem

Hmmm... though interesting, I'm not sure how this relates to the task set before us by the OP. Might just be me who isn't bright enough to see it though. 🙂

This reply was modified 2 years, 11 months ago by kaj.