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 the difference between cluster and non cluster index? : Sql dba

954


What schema means?

843


Explain the rollback statement?

961


What is AUTH_ID and AUTH_USER in pl/sql ?

2135


What is pivot in sql?

870


What is the sql query to display the current date?

989


What are the differences between in and exists clause?

1047


what is a field in a database ? : Sql dba

986


Is there a way to automate sql execution from the command-line, batch job or shell script?

917


what is isam? : Sql dba

950


What is the sql*loader? : aql loader

1003


What is normalization? How many normalization forms are there?

1009


What is a dynamic query?

969


What is database migration?

912


What is the source code of a program?

1001