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 indexing and what are the advantages of it?
What are the elements of dbms?
When columns are added to existing tables, what do they initially contain?
How to invoke a trigger on demand?
Does a server store data?
Tell me about builtinadministrator?
What does normalization do to data?
What is the report model project?
What is difference between views and tables?
Which data type columns are the best candidates for full-text indexing?
What are built in functions?
Does any body please help me what question's have asked for SSRS in the interview?
What functions can a view be used to performed?
What does nvl stand for?
What area unit the various kinds of info compression introduced in sql server 2008?