Hi Everyone...
Consider the following table....
hotel facilities
1 internet
1 swimming pool
1 wi-fi
1 parking
2 swimming pool
2 sauna
2 parking
3 toilets
3 bungee-jumping
3 internet
4 parking
4 swimming pool
I need to select only the hotels that have parking, swimming pool and internet....?
I worked out the following....
SELECT hotel
FROM table
WHERE facilties IN(internet, swimming pool, parking)
This query selects the hotels that has atleast one among the choices.
But what i need is a query that selects the hotels that has ALL of the selected facilities...
Thanks for your suggestions....
Everyone wants to go virtual, but getting started with Oracle’s VM VirtualBox can be tricky. James Koopmann takes a quick look at installing Oracle VM VirtualBox 3.2.4, covering some of the features you as a database administrator or database developer might run across while trying to install an operating system or Oracle database.
HP's new $150 inkjet puts the emphasis on convenience with an extra-friendly touch-screen interface and separate letter and photo paper trays, plus output quality good enough to satisfy business users.
Meeplace is a business review script and content management system that you can install to turn your site into a professional review site, similar to sites like Yelp.
<b>Ubuntu Geek: </b>"This tutorial will explain How to Upgrade Ubuntu 9.10 (Karmic Koala) to Ubuntu 10.04 (Lucid Lynx) released on the 29th April 2010."
For the second time in two years, Wyndham Hotels and Resorts says hackers managed to access its computer systems, stealing personal data including customer payment card data.
<b>Linux Planet:</B> "Take a small box. Add a 64-bit CPU, two SATA hard drives, a Compact Flash slot, dual Gigabit Ethernet, and quiet operation, and what do you have? The VIA M'SERV mini-server. Could this be the perfect Linux box?"
From stolen devices and phishing attacks, to buggy apps and human blunders, 2009 was a banner year for data breaches. Here are 10 from which we can learn a lot.
When Apple dispatched an elite police unit to conduct a literal door-busting raid on a Gizmodo editor's house to confiscate his computers, it seemed a clear case of heavy-handed corporate abuse. But a surprising number of people think it's OK.
<b>Pourquoi pas:</b> "A few days before the release of the new Ubuntu, here's a guided tour through the Ubuntu family album with some annotations telling my story with the different versions."