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
- 21544 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
Which joins are sql server default?
What is the difference between coalesce() & isnull()?
Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.
you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration
explain what is raid and what are different types of raid configurations? : Sql server database administration
How to use "if ... Else if ... Else ..." Statement structures in ms sql server?
what are cursors? : Sql server database administration
What is query and its types?
How do I make a resultset scrollable?
how to create a scrollable cursor with the scroll option? : Sql server database administration
It is important form e to get the information from log files of applications executed by the task scheduler? Does sql studio save these log files? : sql server management studio
Why are sql functions used?
Does a specific recovery model need to be used for a replicated database? : sql server replication
What is full outer join in sql server joins?
Explain different backup plans?
