how to evaluate query by DMBS?
Posted
by Kevinniceguy
on Stack Overflow
See other posts from Stack Overflow
or by Kevinniceguy
Published on 2010-04-11T04:27:34Z
Indexed on
2010/04/11
4:33 UTC
Read the original article
Hit count: 425
How do we evaluate the below database query by DBMS?
the query is something like :
SELECT SUM(price) FROM Room r, Hotel h
WHERE r.hotelNo = h.hotelNo and hotelName = 'Paris Hilton' and roomNo NOT IN
(SELECT roomNo FROM Booking b, Hotel h WHERE (dateFrom <= CURRENT_DATE AND dateTo >= CURRENT_DATE) AND b.hotelNo = h.hotelNo AND hotelName = 'Paris Hilton');
© Stack Overflow or respective owner