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 select 5 to 7 rows from a table, which contains 10 rows?

Answer Posted / john t

If you knowfor sure that the number of rows is 10 then the
above answers given above a great examples. So what if you
don't know the total number of rows in that table? Can you
use Select count(*) from nameoftable;

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Do you know what are different types of replication in sql server?

1103


What method is used by the Command classes to execute SQL statements that return single values?

1075


What the difference between UNION and UNIONALL?

1045


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

1028


How to list all objects in a given schema?

1064


Explain about Views?

1073


Do you know what is a linked server in sql server?

1032


Difference between LEN() and DATALENGTH() in sql server ?

1120


How do I schedule a sql server profiler trace?

984


how would you improve etl (extract, transform, load) throughput?

1033


Can sub report data source be different from that of the parent report?

143


What is a with(nolock)?

987


What are SSL and TSL protocols?

1001


What are the types of normalization?

1033


What are the advantages of using cte?

1023