access²éѯ²»Öظ´

ÎÒÏë²éѯÏÔʾÕû¸ö±íµÄÊý¾Ý¡£µ«ÊÇÌõ¼þÊÇÆäÖÐÒ»Áв»Öظ´µÄÏÔʾ³öÀ´¡£
ÀýÈ磺a b c
      1 2 3
      1 2 4
      1 3 5
½á¹ûÎÒÏëÏÔʾ
      a b c
      1 2 3
      1 3 5

Ò²¾ÍÊÇbÁв»Öظ´

---

up

---

SQL code:
select
*
from
tb t
where
c=(select min(c) from tb where a=t.a and b=t.b)

---

SQL code:
----------------------------------------------------------------
-- Author :fredrickhu(ÎÒÊÇСF£¬Ïò¸ßÊÖѧϰ)
-- Date :2009-12-22 15:08:10
-- Version:
-- Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86)
-- Nov 24 2008 13:01:59
-- Copyright (c) 1988-2005 Microsoft Corporation
-- Developer Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
--
----------------------------------------------------------------
--> ²âÊÔÊý¾Ý£º[tb]
if object_id('[tb]') is not null drop table [tb]
go
create table [tb]([a] int,[b] int,[c] int)
insert [tb]
select 1,2,3 union all
select 1,2,4 union all
select 1,3,5
--------------¿ªÊ¼²éѯ--------------------------
select
*
from
tb t
where
c=(select min(c) from tb where a=t.a and b=t.b)
---------------