Hi every one
I have a table witch have duplicate records. I want to select only unique record with how many time repeated  form table.
My table structure as

CREATE TABLE [dbo].[EmpInfo]
(
  [ID] INT IDENTITY PRIMARY KEY,
  [EmpName] VARCHAR(100)
)
INSERT INTO [dbo].[EmpInfo]  ([EmpName]) VALUES('Chris Roberts')
INSERT INTO [dbo].[EmpInfo]  ([EmpName]) VALUES ('Brad Tutterow')
INSERT INTO [dbo].[EmpInfo]  ([EmpName]) VALUES('Chris Roberts')
INSERT INTO [dbo].[EmpInfo]  ([EmpName]) VALUES ('Brad Tutterow')
INSERT INTO [dbo].[EmpInfo]  ([EmpName]) VALUES ('Paul Mendoza')
INSERT INTO [dbo].[EmpInfo]  ([EmpName]) VALUES ('Zack Peterson')
INSERT INTO [dbo].[EmpInfo]  ([EmpName]) VALUES ('Paul Mendoza')
INSERT INTO [dbo].[EmpInfo]  ([EmpName]) VALUES ('Zack Peterson')
INSERT INTO [dbo].[EmpInfo]  ([EmpName]) VALUES ('Vijay Shukla')

Thank in advance