Your data and requirements are unclear.
If you have something like this:
SCOTT@orcl> SELECT * FROM tbla
2 /
SURGDT MOVEDT
---------- ----------
10/09/2015 10/12/2015
10/12/2015 10/12/2015
10/09/2015 10/23/2015
10/12/2015 10/23/2015
10/15/2015 10/23/2015
5 rows selected.
-- and you are doing this, which is not getting what you want:
SCOTT@orcl> Select * from tblA where surgdt<=Movedt
2 /
SURGDT MOVEDT
---------- ----------
10/09/2015 10/12/2015
10/12/2015 10/12/2015
10/09/2015 10/23/2015
10/12/2015 10/23/2015
10/15/2015 10/23/2015
5 rows selected.
-- it appears that you want something like this:
SCOTT@orcl> SELECT MAX (surgdt) AS surgdt, movedt
2 FROM tbla
3 WHERE surgdt <= movedt
4 GROUP BY movedt
5 /
SURGDT MOVEDT
---------- ----------
10/12/2015 10/12/2015
10/15/2015 10/23/2015
2 rows selected.
] 
Blog
Search
Help
Members
Register
Login
Home
