TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
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 .
Reply
Answers (
2
)
How to add two tables data to the chart from the database?
How to call a output parameter in Web API using post method