Get top 2 rows from each unique field in a column
- by Sai
I have a table named tblItemResources in which I want to get the only 2 rows from each unique field in a column named effectiveDate (order by: ascending):
tblItemResources Table
| empID | effectiveDate | Company | Description
| 0-123…