From the following created table #customer_tbl:

CREATE TABLE #customer_tbl(Col1 datetime, Col2 int, Col3 int, Col4 char(2))

INSERT INTO #customer_tbl Values('2003-07-05', 100131, 715,'AA')
INSERT INTO #customer_tbl Values('2001-03-02', 100142, 700,'AA')
INSERT INTO #customer_tbl Values('2004-09-02', 100154, 38,'AA')
INSERT INTO #customer_tbl Values('2005-08-02', 100113, 73,'AA')
INSERT INTO #customer_tbl Values('2005-08-03', 100234, 78,'BF')
INSERT INTO #customer_tbl Values('2002-01-02', 100357, 706,'BF')
INSERT INTO #customer_tbl Values('2003-01-02', 100052, 706,'BF')
INSERT INTO #customer_tbl Values('2004-01-02', 100291, 706,'BF')
INSERT INTO #customer_tbl Values('2004-06-09', 100317, 390,'DT')
INSERT INTO #customer_tbl Values('2004-06-09', 100139, 700,'DT')
INSERT INTO #customer_tbl Values('2005-08-03', 100154, 38,'DT')
INSERT INTO #customer_tbl Values('2006-07-04', 100113, 73,'DT')
INSERT INTO #customer_tbl Values('2007-03-03', 100234, 78,'KC')
INSERT INTO #customer_tbl Values('2003-01-02', 100348, 706,'KC')
INSERT INTO #customer_tbl Values('2004-11-12', 100556, 706,'KC')
INSERT INTO #customer_tbl Values('2005-01-04', 100741, 706,'KC')

How can I extract the top 2 rows of each Col4 type?

For example:

'2003-07-05', 100131, 715,'AA'
'2001-03-02', 100142, 700,'AA'
'2005-08-03', 100234, 78,'BF'
'2002-01-02', 100357, 706,'BF'
'2004-06-09', 100317, 390,'DT'
'2004-06-09', 100139, 700,'DT'
'2007-03-03', 100234, 78,'KC'
'2003-01-02', 100348, 706,'KC'

I think something like:

Andy

How do you define "top two" out of many?