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
- 26297 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 for auto and for nested?
What are the basic functions for master, msdb, model, tempdb and resource databases?
What is a View ? Can we insert, Update and delete a view?
What is attribute? : sql server analysis services, ssas
You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?
what do you understand by change data capture?
What is the xml datatype?
If any stored procedure is encrypted, then can we see its definition in activity monitor?
What is query and its types?
What is system stored procedures?
How to enter binary string literals in ms sql server?
What is standby servers? Explain types of standby servers.
What are the limitations in ssrs on sql server express edition?
Explain transaction server distributed transaction?
Are connections to sql server encrypted?
