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
Vishnu Bhangale
NA
264
46k
In sql substract next value from previous value and check
Feb 25 2018 10:17 PM
i have data in Log column
Log
8:50
8:50
9:50
10:00
10:00
10:00
13:00
15:00
when i substract next value from previous value and the difference is greater than 5 min then skip the next value and first value store kip as it is in column
ex suppose we substract 10:00 fom 9:50 and diff is greater than 5 min skip the 10:00 and store 9:50
Reply
Answers (
6
)
how to create a table in stored procedure
Stuff Function In Sql Server