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

how many sql ddl commands are supported by 'mysql'? : Sql dba

1031


what does it mean to have quoted_identifier on? : Sql dba

1151


Can I join the same table twice?

1057


What is pl sql code?

1060


How can you load multi line records? : aql loader

1088


Is a foreign key always unique?

950


What is mutating sql table?

1121


What are different types of indexes?

1018


What is primary key and foreign key with example?

940


How do you explain an index?

1287


How many types of triggers are there in pl sql?

1076


What does subquery mean in sql?

1061


What is a .db file?

992


What is the difference between a database and a relational database?

1112


What is pl sql collection?

979