T-Sql Top 3rd Position

• Sanjay Thakur-488205

  SSC Veteran

  Points: 285

  More actions

  September 17, 2008 at 5:14 am

  #212705

  Hi All,

  I have a problem in T-Sql , I Want to See Top 3rd Positional Value in a Table not Top Three.

  Pls any one help me.

  Sanjay Thakur

  DBA-Richagroup

  +91987325028

• ChrisM@Work

  SSC Guru

  Points: 186127

  More actions

  September 17, 2008 at 5:20 am

  #872923

  Hi Sanjay

  Please have a read of this thread: http://www.sqlservercentral.com/Forums/Topic565091-145-1.aspx

  it will help us to help you.

  Cheers

  ChrisM

  ^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

  For fast, accurate and documented assistance in answering your questions, please read this article.
  Understanding and using APPLY, (I) and (II) Paul White
  Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

• steveb.

  SSC-Forever

  Points: 46733

  More actions

  September 17, 2008 at 5:22 am

  #872924

  try this out,

  select top 3 * from YourTable

  except

  select top 2 * from YourTable

  or you can use ROW_NUMBER()

  ;WITH OrderTable AS

  (SELECT *,

  ROW_NUMBER() OVER (order by id)as RowNumber

  FROM YourTable )

  SELECT *

  FROM OrderTable

  WHERE RowNumber = 3;