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 / vishnu
select top 1 * from (select top 5 * from employee order by
empid)sub order by empid desc
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What does the update command do?
How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?
What is use of dbcc commands?
How many cores do I need for sql server 2016?
What are points to remember while using the fillfactor argument?
What is the difference between DATETIME2 and DATETIME?
Explain triggers in sql?
What is single-user mode?
What is user-defined scalar function?
How to get a list of columns using the "sys.columns" view in ms sql server?
Do you know what is a trace frag? Where do we use it?
Are resultset updatable?
How much space does sql server 2016 take?
What are subquery and its properties?
Do you know what is difference between index seek vs. Index scan?