How to select rows.

• putukusuma

  Newbie

  Points: 5

  More actions

  April 8, 2002 at 4:00 am

  #78434

  How I can get the data of record number 50 to 80 from any table on Sql server database.

• Antares686

  SSC Guru

  Points: 125444

  More actions

  April 8, 2002 at 4:39 am

  #426767

  Try the follwoing format if you have a unique item key (not primary key, I mean column or comibnation of columns that are unique) and the table will be ordered by it.

  For this example I have a States table for our service are that contains some, not all, states and I want the 2nd thru 5th states.

  The table is defined in DDL as

  CREATE TABLE [States] (

  [StateIndex] [int] IDENTITY (1, 1) NOT NULL ,

  [statename] [varchar] (50) NULL ,

  [stateNumber] [varchar] (6) NULL ,

  [Abbrev] [varchar] (2) NOT NULL ,

  [Org] [char] (3) NOT NULL CONSTRAINT [DF_States_Org] DEFAULT ('000'),

  CONSTRAINT [PK_States2] PRIMARY KEY CLUSTERED

  (

  [Abbrev]

  ) WITH FILLFACTOR = 90 ON [PRIMARY]

  ) ON [PRIMARY]

  GO

  The query I use the get the states is as follows.

  SELECT * FROM states oSt WHERE

  (SELECT count(abbrev) + 1 FROM States iSt WHERE iSt.Abbrev < oSt.Abbrev) BETWEEN 2 AND 5

  ORDER BY Abbrev

  "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)