bibi92
asked on
compare two time columns
Hello
A table contain millions rows, how can I select row which time is nearly endtime :
SID cost endtime time delta
002200000&&&BBVA 8.096 15:30:00.0000000 15:29:35.0000000 -1
002200000&&&BBVA 8.096 15:30:00.0000000 15:29:58.0000000 -1
Thanks
Regards
A table contain millions rows, how can I select row which time is nearly endtime :
SID cost endtime time delta
002200000&&&BBVA 8.096 15:30:00.0000000 15:29:35.0000000 -1
002200000&&&BBVA 8.096 15:30:00.0000000 15:29:58.0000000 -1
Thanks
Regards
how do you define "nearly endtime" ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
What do you mean? Return only the row with minor delta?