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 is sql sandbox in sql server?
Explain about Normalization?
What is BLOCK statements in SQL?
How to download microsoft sql server 2005 express edition?
Explain the benefits of user-defined functions?
Explain triggers in sql?
What do you understand by check constraint in sql server?
If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security
What are the basic features of a trigger in ms sql server?
What will happen if a column containing char type data is changed to the nchar data type?
How do you clear a log file?
What is intellisense?
Explain a differential backup?
How can you start sql server in different modes?
What is the purpose of linked server configuration in sql server?