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
- 21513 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
If any stored procedure is encrypted, then can we see its definition in activity monitor?
What are the disadvantages of indexes?
How to generate create view script on an existing view?
How to create a new schema in a database?
What is user-defined function?
What is the purpose of object explorer and its features? : sql server management studio
How do I get Report Builder to generate a parameter that can be set by users viewing the report?
what is a join? : Sql server database administration
What is the difference between varchar and nvarchar datatypes?
What is extended stored procedures?
What do you mean by stored techniques? How would we use it?
How to encrypt data between dialogs?
What is sql server management studio? : sql server management studio
What are translations and its use? : sql server analysis services, ssas
Why do you need a sql server?
