SQL Command help

[SuduuNangiya]

can anyone tell me the SQL command to display only records which repeating.
Ex. if there are people who were born in same day . . .
SELECT * FROM aaa WHERE ?????????????

Thanks in advance.

 

[chintha4u]

can anyone tell me the SQL command to display only records which repeating.
Ex. if there are people who were born in same day . . .
SELECT * FROM aaa WHERE ?????????????

Thanks in advance.

group by date eken deela, count eka 1ta wadi eewa gaththoth ????

 

[rasithaudayanga]

Sql Query

can anyone tell me the SQL command to display only records which repeating.
Ex. if there are people who were born in same day . . .
SELECT * FROM aaa WHERE ?????????????

Thanks in advance.

Select *
From Tablename
Where birthday=(SELECT birthday FROM Tablename GROUP BY birthday
HAVING ( COUNT( birthday) > 1 ))

200% Working Already Tested

 

[hspa3.5]

Select *
From Tablename
Where birthday=(SELECT birthday FROM Tablename GROUP BY birthday
HAVING ( COUNT( birthday) > 1 ))

200% Working Already Tested

oka hariyata hari