Archive for November 26th, 2008
SQL – Filtering WHERE condition on two rows
November 26th, 2008 | 
Author: 
I received the following question a couple of days ago from a programmer using the “Ask a Question” form which you can access from the menu of this blog:
Given the following table:
| Name | Language |
| Nikhil | Hindi |
| Nikhil | English |
| Kisu | Hindi |
| Kisu | English |
| Rakesh | Hindi |
| Kousik | Bangali |
How do I select names of persons who know both Hindi and English?
In this table, that query should return Nikhil and Kisu.
Other Related Items:
Star Wars Galactic Hero TIE Pilot & WedgeThe Galactic Heroes, a more child-based strain of the Star Wars line, are about two inches tall and look to have a little articulation to them. Wedge,... Read More >
Microsoft SQL Server 2000 Administrator's Pocket Consultant (It-Administrator's Pocket Consultant)If specialization is for insects, those of us who have only two legs are bound to need reminders when we sit down to perform a specialized task. For... Read More >
F Female To F Female Coax Cable Joiner (20 Pack)This F Female to F Female Joiner will join two coax cables with male F-connectors on each end. This joiner is commonly used to extend the length of an existing piece of coax cable and will work with all types of F connectors (RG-59 and RG-6.)
Posted in 
Tags: 
