OraFAQ Forum: SQL & PL/SQL » How to query records with same value in specific columns from a table

Home » SQL & PL/SQL » SQL & PL/SQL » How to query records with same value in specific columns from a table

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

Re: How to query records with same value in specific columns from a table [message #18377 is a reply to message #18373]

Tue, 29 January 2002 15:36

Suresh Vemulapalli
Messages: 624
Registered: August 2000

Senior Member

select a.name,a.sex,a.age from tab1 a,(select * from tab2 group by name,sex having count(*)>1) b
where a.name=b.name and a.sex=b.sex;

Report message to a moderator

Previous Topic:	Duplicates
Next Topic:	Help, procedure not compiling

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 05:39:05 CDT 2024