cat1 date1 amount cat1 date2 amount cat1 date3 amount cat1 date4 amount cat2 date1 amount cat2 date2 amount cat3 date1 amount cat3 date2 amount cat3 date3 amountI want to get the oldest 2 dates from each category into a table. I want my table to look like the following:
cat1 date1 amount cat1 date2 amount cat2 date1 amount cat2 date2 amount cat3 date1 amount cat3 date2 amountAny easy way to do this with a select that I am overlooking?