to find a nth row in a table select top n * from <TableName> exce

how to find the particular row in table?(means suppose one
table contain 10 rows , in these 10 rows how to find the
particular row(example in 10 rows i want 5 row how)?

Question Posted / murthy

16 Answers
25225 Views
Accenture, IBM, Marlabs, I also Faced
E-Mail Answers

Answer Posted / murthy

to find a nth row in a table

select top n * from <TableName>
except
select top n-1 * from <TableName>

Is This Answer Correct ?

2 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Do you know concepts and capabilities of sql server?

1006

What type of locking occurs during the snapshot generation? : sql server replication

1262

What is Dependency Injection and provide example?

1040

in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it

1453

Explain about analysis services?

980

what's the difference between delete table and truncate table commands? : Sql server database administration

921

Is it possible to create trigger on views?

934

What is BLOCK statements in SQL?

1206

How to find related tables in sql server?

871

What is the difference between char, varchar and nvarchar?

978

Is sql server a database?

924

How to restore performance issues and how to check?

1949

List the different types of collation sensitivities in sql server?

973

What is instead of dml trigger?

951

What is a bit datatype?

924