lundi 13 février 2017

Request for checking whether a record exists in another date

Vote count: 0

I have question because I want to make a query in PL/SQL. With my query I get score oso_pm and ja chciałbym teraz sprawdzić, czy otrzymane dane znajdują się w tej samej tabeli, ale dla wr > '2012-12-30 22:42:56'. Which has the first query returns me oso = 3 and I want to see if oso = 3 is also the '2012-12-30 22:42:56'

select oso
       from p.cn_clausule k
      where
      wr >= '2010-09-01 08:08:08'
   and wr <= '2012-12-30 22:42:56'
     -- and k.pm <= 1340845
   and st = 1

asked 5 secs ago

Let's block ads! (Why?)



Request for checking whether a record exists in another date

Aucun commentaire:

Enregistrer un commentaire