how to retrieve a particula row from a table. where table have only one column name.

Question

0.00/5 (No votes)

See more:

SQL

table have only one column name.i have to retrieve a particular row number,like 5th,6th

Posted 12-Aug-15 22:23pm

manish-gusain8909

Add a Solution

Comments

Maciej Los 13-Aug-15 4:32am

Sample data would be helpful! What you mean by saying: 5th, 6th row?

3 solutions

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)

Arasappan · Answer 1 · 2015-08-12T23:23:00

Solution 4

Hi Manish,

SQL

SELECT * FROM (
  SELECT
    ROW_NUMBER() OVER (ORDER BY columnname ASC) AS rownumber,
  columnname
  FROM tbl_studreg

) AS foo
WHERE rownumber =5 or rownumber = 6

DEfinitely it will work :-):-)

Improved Answer

SQL

SELECT * FROM (
  SELECT
  ROW_NUMBER() OVER (ORDER BY ID ASC) AS rownumber,
  ID
  FROM tablename

) AS foo
WHERE ID =5

For "ID" Replace ur condition column

The condition column name must be primary key

Posted 12-Aug-15 23:23pm

Arasappan

Updated 13-Aug-15 3:27am

v6

Comments

manish-gusain8909 13-Aug-15 8:50am

we cant have where conditions on row_number,rank() .

Arasappan 13-Aug-15 8:53am

please clearly explain

Arasappan 13-Aug-15 9:14am

see my improved answer.output 100% sure :-)

Arasappan 14-Aug-15 0:27am

take the idea from the answer and modify as per ur need.. thank u

KapilMuni · Answer 2 · 2015-08-12T23:12:00

Solution 2

Hi Manish ,
try this

Solution 1:- Row_Number () function
Cons :-Row_Number sort the Column value so that u cant not retrieve exact value at that row number as it is in Original Table .

Solution 2:-
Declare @tbl (ID int Identity(1,1), ColumnVal varchar(100))
Insert into @tbl
Select ColumnName from Table --(your table with Column name )

Select columnVal from @tbl where ID=5 (Or 6 What ever u want);

Hope it helps u lot .
:)

Posted 12-Aug-15 23:12pm

KapilMuni

Updated 12-Aug-15 23:22pm

v2

Comments

manish-gusain8909 13-Aug-15 8:48am

in table i have only one column, i dont have id column.

KapilMuni 13-Aug-15 9:13am

Dear Id column is Identity field, which is auto generated. it helps to find the nth position of data value .Still u have concern contact 7838018036

DamithSL · Answer 3 · 2015-08-12T23:02:00

Solution 1

refer : Row Numbers in SQL Query (Microsoft SQL Server 2000 and 2005)[^]

Posted 12-Aug-15 23:02pm

DamithSL