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 / ashim pal

set rowcount 5

select * from table_name

Is This Answer Correct ?    7 Yes 16 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is perspective, have you ever created perspective? : sql server analysis services, ssas

859


What is left outer join in sql server joins?

969


How ssrs maintain security?

1016


How to add more data to the testing table in ms sql server?

1000


State the difference between local and global temporary tables?

1048


What is read uncmmited?

1010


Create and insert into temp table in sql server?

977


How can we improve performance by using SQL Server profiler?

984


How should i optimize the time for execution of stored procedure having single input and many output from the different tables?

1851


How to handle error or exception in sql?

935


What is resource governor?

926


How would you use user_constraints table in DB?

939


Will count(column) include columns with null values in its count?

1033


How to rebuild all indexes on a single table?

995


What are built in functions?

951