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...

suppose u hav 1 book with set...page 1-100 n 101 -200
now print page from 2-100 n 102 -200...
how we will do..?

Answer Posted / tamilarasan

Say you have table with column "page_no" starts from 1 to
200.

Run the below query to get the desired answer

select page_no from book1 where mod(page_no,100) != 1

Is This Answer Correct ?    4 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can a key be both primary and foreign?

946


what's the difference between a primary key and a unique key? : Sql dba

973


What is varchar sql?

1060


what are the security recommendations while using mysql? : Sql dba

1051


How can I get the number of records affected by a stored procedure?

1003


What is pl/sql language case sensitive?

1061


List the different type of joins?

1004


Can you join views in sql?

897


How to find 3rd highest salary of an employee from the employee table in sql?

1038


What is primary key sql?

953


What is the sql*loader? : aql loader

1006


how to check server status with 'mysqladmin'? : Sql dba

1018


how to convert numeric values to character strings? : Sql dba

1038


Is primary key always clustered index?

948


Where is all the data on the internet stored?

949