How to select a row with a missing entry in historization?
Posted
by
Viper
on Stack Overflow
See other posts from Stack Overflow
or by Viper
Published on 2011-11-14T09:41:43Z
Indexed on
2011/11/14
9:51 UTC
Read the original article
Hit count: 207
from the following data basis i need to select all IDQ's which do not have an entry for the 11.11.2011.
IDQ | DATE
----------------
1 | 08.11.2011
1 | 09.11.2011
1 | 10.11.2011
1 | 12.11.2011
1 | 13.11.2011
i can't figure out how to express the sql
select
IDQ
from
TBL_WITH_IDQ T
where not exists ( DATE = '11.11.2011' ) // sql does not the job
Database is a Oracle 11g.
maybe someone can help me?
© Stack Overflow or respective owner
