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

Filed under:
|
|
|

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

Related posts about database

Related posts about dbms