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 retrieve range of 10th rows to 20 th rows from total
rows from a database table.? (Not from Dataset)

Answer Posted / govardhana r

use Row_Number() function to check for the condition so
that the row number is between 10 and 20

Is This Answer Correct ?    10 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many full-text indexes can a table have?

1026


How to throw custom exception in Stored Procedure?

1096


Do you think BCNF is better than 2NF & 3NF? Why?

1338


What is @@error in sql?

1109


What is resource governor in sql server?

1049


how to determine the service pack currently installed on sql server? : Sql server database administration

1026


What are different types of statements that are supported by sql?

1099


What are the various Operating system files that every SQL server 2005 database has and what is the purpose.

1116


Why and when do stored procedure recompile?

1029


Sql studio em braces a variety of capabilities, but will I need them all? Is there a simpler product ? : sql server management studio

952


What happens when converting big values to numeric data types?

1227


Difference Between ORDER BY Clause and GROUP BY Clause in SQL?

1104


How to remove duplicate rows from table except one?

1064


What are cursors and when they are useful?

1151


What do you do in data exploration

1050