SELECT t.EmployeeName,t.MailID,t.MailName,t.MailDate
FROM
(SELECT ROW_NUMBER() OVER(PARTITION BY e.EmployeeName ORDER BY m.MailID) AS RowNo,
e.EmployeeName,m.MailID,m.MailName,n.MailDate
FROM Employee e
INNER JOIN Mail m
ON m.EmployeeID=e.EmployeeID
)t
WHERE t.RowNo % 3 =0

SELECT M.*, E.*
FROM Mail M 
     INNER JOIN Employee E ON M.EmployeeID = E.EmployeeID
WHERE ((SELECT COUNT(M_Sub.MailID) 
        FROM Mail M_Sub 
        WHERE M_Sub.EmployeeID = M.EmployeeID AND M_Sub.MailID <= M.MailID) % 3)= 0

quote:

---

Originally posted by Dallr

This will work in any version and it might also be faster than Visakh16 option. You can test it to make sure.

SELECT M.*, E.*
FROM Mail M 
     INNER JOIN Employee E ON M.EmployeeID = E.EmployeeID
WHERE ((SELECT COUNT(M_Sub.MailID) 
        FROM Mail M_Sub 
        WHERE M_Sub.EmployeeID = M.EmployeeID AND M_Sub.MailID <= M.MailID) % 3)= 0

PS: Visakh16 there is a little typo in your sql. N.Maildate should be. M.maildate

Dallr

---