Interested to Buy Any Domain ? << Click Here >> for more details...
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)?
- 16 Answers
- 26256 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
what happens on checkpoint? : Sql server database administration
What is an identity?
Explain what are the database objects? : SQL Server Architecture
How can I tell if sql server is 32 or 64 bit?
What is normalization? Describe its different types.
What is a trigger? Why we need it?
What is difference between clustered and non clustered index?
Can you tell me about the concept of ER diagrams?
What is role playing dimension with two examples? : sql server analysis services, ssas
What is the importance of three tier architecture?
What is a document index?
How to find which stored procedure is currently running in sql server?
Do you know what are various aggregate functions that are available?
How to disable stored procedure sql server?
How to loop through the result set with @@fetch_status?
