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
- 25473 Views
- Accenture, IBM, Marlabs, I also Faced
- E-Mail Answers
Answer Posted / kishor
select top 1 * from table_name
where id in (select top 5 id from table_name order by id asc)
order by id desc
| Is This Answer Correct ? | 3 Yes | 4 No |
Post New Answer View All Answers
How to replace null values in expressions using isnull()?
Explain in brief how sql server enhances scalability of the database system?
Tell me the difference between clustered and non-clustered index?
What is meant by indexing?
How global temporary tables are represented and its scope?
Can sql servers linked to other servers?
What are the instances when triggers are appropriate?
What is bookmark link in ssrs?
If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio
what is normalization? : Sql server database administration
What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?
How will you optimize a stored procedure optimization?
What is the security principal at the server level that represents your session?
How to automatically create a log when an exception is being received into SQL Server?
What are character string data types in ms sql server?
