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 drop and truncate commands?

1115


How many types of sql are there?

1047


How do you modify a table in sql?

1167


What is rename command in sql?

1095


Why are indexes and views important to an organization?

1000


what is a constraint? : Sql dba

1235


Can we join 3 tables in sql?

1111


What is primary key in db?

1074


What is replication id?

989


Explain the difference between sql and mysql.

1113


How do you delete a table?

1124


What is the difference between having clause and where clause?

1117


What is join view in sql?

989


How do I view a sql trace file?

1065


How do you remove duplicates without using distinct in sql?

1019