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

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 .
:)

Hi Manish,

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

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