Query to get a particular row in Sql Server 2005

Anky Goyal 19 May 2009 Microsoft, sql server Views: 16,251 views

In this article we will look into how to write a sql query to get a particular row in sql.

Lets write the code to find 2nd row in a table named mcc_measures.

So first we declare a temporary table

declare @temp table (id int)

No in this temp table we insertrow numbers of the table


insert into @temp(id)

SELECT 
ROW_NUMBER() over(ORDER BY Measure_Id DESC)
FROM 
mcc_measures

Now from the temp table we select the row where rowid=2 as required

SELECT
*
FROM
@temp
WHERE
id = 2

Anky Goyal

I am MCPD certified in .NET and working on .NET technologies for past 3yrs. I am very passionate about the new features which get introduced in the technology. I am here to share the new features i get to know in the world of Microsoft. Follow me on twitter @ankygoyal LinkedIN@Ankit Goyal

12 Responses to Query to get a particular row in Sql Server 2005

KattyBlackyard

Jun 15, 2009

Original post by Dmitri Gromov

reply
- Ankit Goyal
  
  Jun 19, 2009
  
  Hi KattyBlackYard,
  
  Well the query written above is very basic query and i do not know what Dmitri Gromov has written on the topic.
  Please provide me the URL of the article you are talking of, so that i can send pingbacks to it.
  
  reply
fkawau

Aug 17, 2012

This is the turn Query to get a particular row in Sql Server 2005 | Techartifact blog for anyone who wants to seek out out most this content. You observation so more its near debilitating to converse with you (not that I really would want…HaHa). You definitely put a new twirl on a theme thats been holographic most for years. Prissy block, only great!

reply
Free Point android apps

Aug 31, 2012

This is the penalize Query to get a particular row in Sql Server 2005 | Techartifact diary for anyone who wants to essay out out almost this matter. You mention so often its nigh effortful to contend with you (not that I real would want…HaHa). You definitely put a new rotation on a matter thats been cursive roughly for years. Squeamish shove, simply eager!

reply
tomtom android download

Nov 05, 2012

Wow, superb blog layout! How long have you been blogging for? you made blogging look easy. The overall look of your site is great, let alone the content!. Thanks For Your article about Query to get a particular row in Sql Server 2005 | Techartifact .

reply
MMO

Feb 05, 2013

Simply wanna comment on few general things, The website design is perfect, the articles is real wonderful. “The sun sets without thy assistance.” by The Talmud.

reply
read more

Feb 06, 2013

I like this site very much, Its a rattling nice place to read and incur information. “The absence of war is not peace.” by Harry S Truman.

reply
mesothelioma information on-line

Feb 06, 2013

Keep up the good work , I read few articles on this website and I conceive that your site is real interesting and has sets of good info .

reply
website

Feb 06, 2013

You are my breathing in, I have few web logs and often run out from post . “Fiat justitia et pereat mundus.Let justice be done, though the world perish.” by Ferdinand I.

reply