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


Please Help Members By Posting Answers For Below Questions

What is the new security features added in sql server 2014? : sql server security

753


what is a mixed extent? : Sql server administration

751


What is standby servers? Explain types of standby servers.

675


How fixed length strings are truncated and padded?

721


What is report rendering ?

131






What is the maximum size per database for sql server express?

742


What are the difficulties faced in cube development? : sql server analysis services, ssas

797


What are date and time data types in ms sql server?

729


how many layers of tcp/ip protocol combined of? : Sql server database administration

720


What is SQL Azure Firewall?

128


What functions can a view be used to performed?

796


How to rename an existing column with the "sp_rename" stored procedure in ms sql server?

779


Which tools are available to manage SQL Azure databases and servers?

107


Explain forward - only cursors?

703


What is log shipping?

727