¡¾¸Äб¹éÕý¡¿ sqlserver sql ·ÖÒ³Óï¾ä

      ÔÚGoogleÉÏʹÓÓsql ·ÖÒ³”¹Ø¼ü×Ö½øÐÐËÑË÷£¬¼¸ºõËùÓеĴ𰸶¼ÊÇÄÇÈýÌõ¡£Æä¶þЧÂÊ×î¸ß£¬ÆäÈýʹÓÃÓα꣬ЧÂÊ×î²î¡£
      ÏÂÃæÊÇÄÇÈýÖÖ·½·¨ £¨²åÈë´úÂëûÓÐsqlÑ¡Ï
·½·¨1£º
ÊÊÓÃÓÚ SQL Server 2000/2005
SELECT TOP Ò³´óС *
from table1
WHERE id NOT IN
(
SELECT TOP Ò³´óС*(Ò³Êý-1) id from table1 ORDER BY id
)
ORDER BY id
·½·¨2£º
ÊÊÓÃÓÚ SQL Server 2000/2005
SELECT TOP Ò³´óС *
from table1
WHERE id >
(
SELECT ISNULL(MAX(id),0)
from
(
SELECT TOP Ò³´óС*(Ò³Êý-1) id from table1 ORDER BY id
) A
)
ORDER BY id
·½·¨3£º
ÊÊÓÃÓÚ SQL Server 2005
SELECT TOP Ò³´óС *
from
(
SELECT ROW_NUMBER() OVER (ORDER BY id) AS RowNumber,* from table1
) A
WHERE RowNumber > Ò³´óС*(Ò³Êý-1)
      ´ÖÂÔ¿´ÁË£¬ÕâÈýÖÖ·½·¨¶¼Ã»ÓÃ´í¡£ËµµÄ¶¼ÓÐÀí¡£Ïà¶ÔÀ´ËµÇ°Á½ÖÖ·½·¨¶ÔÓÚ´øÌõ¼þµÄ²éѯ²»¹»·½±ã¡£
      ÖÁÓÚЧÂÊ£¬½ñÌìʵ¼Ê¼ÓÁËÌõ¼þ²âÊÔһϡ£Êµ¼ÊËٶȲ¢²»ÊÇ·½°¸2×î¿ì£¬·½°¸3×îÂý¡£Êµ¼ÊÇé¿öÊÇ·½°¸3×î¿ì£¬·½°¸1´ÎÖ®£¬·½°¸2×îÂý¡£ÓëÍøÉϽá¹û½ØÈ»Ïà·´¡£µ«ÊÇ·½°¸3ÓÐÒ»¸ö·Ç³£Òª½ôµÄ´íÎó£ºÃ»ÓÐÅÅÐò¡£Ö±½ÓʹÓÿÉÄܻᵼÖ´íÎó¡£
      ²»¼ÓÌõ¼þµÄ²âÊÔ½á¹ûÊÇÒ»ÑùµÄ¡£
      ·½°¸3µÄÕýÈ·Ó÷¨ÊÇ£º
SELECT TOP 10 * from tt
SELECT TOP Ò³´óС *
from
(
SELECT ROW_NUMBER() OVER (ORDER BY id) AS RowNumber,* from table1
) A
WHERE RowNumber > Ò³´óС*(Ò³Êý-1) ORDER BY RowNumber
ÒÔÏÂÊDzâÊÔ·½°¸¡£
´´½¨ÏÂ±í£º
USE [BigDb]
GO
/****** Object: Table [dbo].[t7] Script Date: 02/20/2010 20:35:34 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[t7](
[id] [int] IDENTITY(1,1) NOT NULL,
[pid] [int] NOT NULL,
[sex] [bit] NOT NULL,
[name] [nchar](5) COLLATE Chinese_PRC_CI_AS NOT NULL,
[age] [int] NOT NULL,
[time] [datetime] NOT NULL,
[note] [ntext] CO