How to query records with same value in specific columns from a table [message #18373] |
Tue, 29 January 2002 14:16 |
Hung Sheng Chen
Messages: 1 Registered: January 2002
|
Junior Member |
|
|
Dear all,
1. I am writing a sql to query records with same value in specific columns from a table. For example,in below table, I want to query records with the same name in the same sex. So,the result should be two records with the name Mary.
2. Please tell me how to write the SQL statement?
Name Sex Age
---- --- ---
Mary F 23
John M 40
Mary F 45
|
|
|
|