SQL 查询每组最大的两个值

USE [tempdb]
GO
/****** 对象:  Table [dbo].[Table_1]    脚本日期: 06/20/2008 12:46:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Table_1](
[userid] [int] NULL,
[uname] [nvarchar](50) NULL,
[type] [nchar](10) NULL
) ON [PRIMARY]

SELECT A.userid, A.uname, A.type
FROM        
(
SELECT TOP 2 * FROM
Table_1
WHERE     (uname = 'a')
ORDER BY userid DESC
) AS A
UNION
SELECT B.userid, B.uname, B.type
FROM        
(
SELECT TOP 2 * FROM
Table_1
WHERE     (uname = 'b')
ORDER BY userid DESC
) AS B
ORDER BY uname, userid DESC