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
is it important for a database administrator to understand the operating system and file access? : Sql server administration
What is dknf in normalization form?
What program is used to store the data source file?
How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?
What is the boxing and unboxing concept in .net?
How to retrieve field values using mssql_result()?
Does sql server 2000 clustering support load balancing?
Which rendering formats are affected by the pagesize properties?
Why is normalisation important?
What is normalization? Explain different forms of normalization?
Explain the etl (extraction, transformation, and loading)?
Mention the differences between having and where clause.
How to see existing views in ms 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 is a transaction and what are acid properties? : Sql server database administration