why the SQL select query will fail even thougth condition satisfies [on hold]

SQL query got failed even though condition satisfies..
There is a query which needs to fetch the records between start and end times…there are around 130 records which satisfies the condition, but the condition has picked only 120 records, and did not pick remaining 10…
What could be the reason


Source: sql

Leave a Reply