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

What is sql deadlock?

1149


How do you modify a column in sql?

1003


How does pl sql work?

967


How is a PL/SQL code compiled?

1240


Can we use the cursor's to create the collection in PL/SQL?

1031


Can a foreign key have a different name?

944


What is difference between pls_integer and integer?

969


What is the purpose of my sql?

954


What is a primary key called that is made up of more than one field?

1354


What are stored procedures in mysql?

1021


What is scope and visibility in PL/SQL?

1210


How many types of tables are there?

955


How do I view a table in sql?

1013


Can we use view in stored procedure?

905


How to select all records from the table?

1141