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)?
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
What will be the maximum number of indexes per table?
Write a SQL queries on Self Join and Inner Join.
what are the different types of SSRS reports?
What is simple indexing method?
What is snapshot replication?
Explain what is the difference between a local and a global temporary table?
What is the contrast between sql and mysql?
Explain nested trigger in sql?
whats the maximum size of view state??
How to convert numeric expression data types by assignment operations?
what is the maximum size of a row? : Sql server database administration
How to read data in a table with "select" statements?
Can you explain full-text query in sql server?
Write an sql query to find first weekday of the month?
What are the differences between char and varchar in ms sql server?