Link to home
Start Free TrialLog in
Avatar of bibi92
bibi92Flag for France

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
Avatar of Ryan Chong
Ryan Chong
Flag of Singapore image

how do you define "nearly endtime" ?
ASKER CERTIFIED SOLUTION
Avatar of Brian Crowe
Brian Crowe
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
What do you mean? Return only the row with minor delta?