Solve this Query

[SoniHarsh]

Hello friends,

I want to find only fifth row from a table please give me better solution.

thanks in adavance

regards
Harsh

[skhanal]

Do you have any sequence column in the table?

[moeedkreated]

Select Top 5 From Table_name
Order By Column_name Desc

[Lydic]

Relational Database Law (Or should be):

Never assume the order of the rows after insertion or retrival unless bound by an ordering clause.

And even with an ordering clause, you have to be extremely careful.

Select top 5 from table_name

If connecting through an app, burn through the first 4 results, and tada. If its a t-sql query, cursor through the result set and burn the first 4 lines.

but again, be careful. If you are ordering, moeedkreated's statement works.

[vanaspati]

run this query

select top 1 * from (select top 5 * from Table_Name order by Column_Name desc) Table_Name

This will give you the fifth row