Abdalla Omran

Abdalla Omran

  • NA
  • 334
  • 32k

How to get the entries where the difference between two col

Aug 22 2019 4:45 AM
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 .
 

Answers (2)