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

If you run this query select page_no from book1 where mod
(page_no,100) != 1

in a single column u will get the page nos as follows

RESULT
-------
2.
...
100
102
...
200

Is this the one you want?

Is This Answer Correct ?    4 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I remove all records from a table?

1061


What is bulk collect in pl sql?

1072


What does the sign mean in sql?

966


Why should I use postgresql?

998


Can we create clustered index without primary key?

948


What is character functions?

1043


What is program debugging?

1217


What is a sql select statement?

1021


What is full join?

930


How can a function retun more than one value in oracle with proper example?

1061


Why do we use procedures in pl sql?

1007


How do you write an index?

948


what is the command line end user interface - mysql? : Sql dba

964


What is a unique key and primary key and foreign key?

954


Is it possible to create the following trigger: before or after update trigger for each row?

1272