Quote:
Originally posted by chrisrlong
Additionally, we need to know if that column is indexed, and whether or not this simplified example is anywhere close to what your real-world SQL will be. This sql is trying to say 'get me the latest entry in the entire table.
I am trying to get the latest entry from the table which is before sysdate. it can be sysdate-1 or sysdate-100.
Quote:
Originally posted by chrisrlong
However, unless there is a unique index on that date column, it is possible to return more than one row from this SELECT. Is that what you want?
Yes, the Trade date column has a unique index on it and should return only one row.