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
- 25661 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 normalization? Explain different levels of normalization? : Sql server database administration
What is a rownum?
What is an inner join?
What is the difference between varchar and varchar types?
What is the syntax to execute the sys.dm_db_missing_index_details?
explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
Differentiate between delete and truncate.
What are scalar functions?
Do you know what are the reporting services components?
what is new philosophy for database devises for sql server 7.0? : Sql server database administration
What is the status of services on passive node for failover cluster in sql server? : sql server database administration
Explain error handling in ssis?
What is the purpose of forms?
Explain about merge replications?
What is primary key, unique key, and foreign key?
