Answer Detail: RE: How we can count duplicate entery in particular ta...

GeekInterview.com > Interview Questions > Database > MYSQL

Print |

Question: How we can count duplicate entry in particular table against Primary Key ? What are constraints?

March 03, 2006 04:49:39	#1
rajendarb	Database Expert Member Since: March 2006 Total Comments: 1
RE: How we can count duplicate entery in particular ta...
select count() from tablename where count() >1 group by empno; ( jst checkin for to count duplicate records if not jst send reply to me) thanx