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 / guest
select top 1 * from table_name where id in(select top 5 id
from table_name order by desc)
| Is This Answer Correct ? | 9 Yes | 5 No |
Post New Answer View All Answers
Explain how to send email from sql database?
In what version of sql server were synonyms released?
What are the differences between clustered and non-clustered index?
What is a database table?
Is sql server is free?
In what sequence sql statement is processed?
How to update a field in SQL after ALTERING a row?
Where to find ntwdblib.dll version 2000.80.194.0?
Tell me what are cursors and when they are useful?
Do you have any idea about the tcl commands?
What is the most common trace flags used with sql server?
What are trace files?
What is the Main Difference between ACCESS and SQL SERVER?
What are the types of table?
What is the full meaning of dml?