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
What is the new security features added in sql server 2014? : sql server security
what is a mixed extent? : Sql server administration
What is standby servers? Explain types of standby servers.
How fixed length strings are truncated and padded?
What is report rendering ?
What is the maximum size per database for sql server express?
What are the difficulties faced in cube development? : sql server analysis services, ssas
What are date and time data types in ms sql server?
how many layers of tcp/ip protocol combined of? : Sql server database administration
What is SQL Azure Firewall?
What functions can a view be used to performed?
How to rename an existing column with the "sp_rename" stored procedure in ms sql server?
Which tools are available to manage SQL Azure databases and servers?
Explain forward - only cursors?
What is log shipping?