question in sql server

Question

1.00/5 (2 votes)

See more:

SQL-Server

Hi..i want nth row from a selected table with out using any column name.Can any one help..in sql server.

Posted 30-Jan-12 19:42pm

hussy rao

Updated 26-Jan-17 19:19pm

Add a Solution

4 solutions

Solution 1

I Hope This Will Help U.

http://blog.lysender.com/2010/10/sql-server-select-nth-row/[^]

Good Day

Posted 30-Jan-12 19:51pm

CRDave1988

Solution 3

you can use

ROW_NUMBER()

and get nth row

Posted 30-Jan-12 20:29pm

AditSheth

Updated 30-Jan-12 20:33pm

v2

Comments

hussy rao 31-Jan-12 2:39am

sorry sir im not getting the result..

Solution 4

Here n is the row number.

SELECT * FROM (
  SELECT
    ROW_NUMBER() OVER (ORDER BY key ASC) AS rownum,
    columns
  FROM tablename
) AS foo
WHERE rownum <= n

Hope,this helps.

Posted 26-Jan-17 19:19pm

Neha Ambasta

Updated 26-Jan-17 19:20pm

v2

Comments

[no name] 27-Jan-17 7:12am

The question was asked and answered FIVE years ago.

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

uspatel · Accepted Answer · 2012-01-30T20:26:00

Solution 2

Use Column name in order by

SQL

SELECT * FROM
(
   SELECT empbirth.*, ROW_NUMBER() OVER (order by name) AS RowNum from empbirth
) sortly
WHERE RowNum =8

but if you do'nt want to use col name then you can try as

SQL

SELECT * FROM
(
   SELECT empbirth.*, ROW_NUMBER() OVER (order by (select top 1 column_name from information_schema.columns
 where table_name = 'empbirth')) AS RowNum from empbirth
) sortly
WHERE RowNum =8

Hope it solves your problem

Posted 30-Jan-12 20:26pm

uspatel

Comments

hussy rao 31-Jan-12 2:32am

Thank You..But this is working in latest versions of sql server2008 not in 2000,2005..thank you

uspatel 31-Jan-12 2:43am

In sql server 2000 , there is no function ROW_NUMBER().
but you can search alternatives of ROW_NUMBER() on Google...