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
- 25834 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 is the difference between seek predicate and predicate?
How to provide default values to stored procedure parameters?
What is BLOCK statements in SQL?
What are the different types of lock modes in sql server 2000?
Explain filtered indexes benefits?
What is the usage of sign function?
Explain raiserror in sql server?
Differentiate between delete and truncate.
Differentiate between a local and a global temporary table?
How is sql used in sql server?
Can group by be used without aggregate functions?
Why do we need different type of parameter?
Write a SQL command to insert and update only a particular field?
Are null values the same as that of zero or a blank space?
Can truncate be rolled back?
