Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

How to Sync Two SQL Azure Databases?

119


How to delete all rows with truncate table statement in ms sql server?

930


Should you normalize audio?

879


Can multiple columns be used in sql group by clause in ms sql server?

985


How to count groups returned with the group by clause in ms sql server?

1006


how we use window authentication connection with sql server.?

1084


What is a transact-sql statement batch in ms sql server?

946


Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?

995


In what three ways is the return statement used in a stored procedure?

954


What is dbcc?

1082


What are the advantages of using cte?

951


Do you know sql server 2008 introduces automatic auditing?

907


What is the difference between functions and stored procedures?

1091


How you can find out if an index is useful to the optimizer?

871


How to delete multiple rows with one delete statement in ms sql server?

942