How to Calculate Number of times repeated same records.

Question

How to Calculate Number of times repeated same records. For Example: Emp No 1 how many times get Salary. i want count this details. Thanks&Regs Manavalan

Krishna Garad · Answer

you can try Select Count(*)From TblName Where EmpNo=1;