How to get the entries where the difference between two Columns bigger as 2 min and then get just the top 100 entreis ?
I have two Datetime Columns which they called :
AddedToQueue / LastStatusUpdate
2019-03-13 12:06:43.0430000 / 2019-03-21 17:50:00.0000000
thats just an Example i have 8000 records and want to an Query to find the difference between those two columns where difference bigger as 2 min and then select the top 100 and sorted them by AddesToQueue .
I will be so glad for your help .
2 Replies
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Amit MohantyPosted Aug 22, 2019, 5:19 AM
Abdalla OmranPosted Aug 22, 2019, 5:47 AM