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 to write html code in pl sql?

1161


What is the left table in sql?

1015


What is nvarchar max in sql?

1076


Is it possible to update views?

1007


What is java sql drivermanager?

1161


What do you mean by dbms? What are its different types?

1065


What is a trigger word?

1081


What is example of database?

1135


What is sql server and ase?

1072


How do I find duplicates in sql?

983


what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba

1080


Is record in pl sql?

1013


How do I count rows in sql?

1052


How to rename a column in the output of sql query?

1131


How do I know if I have sql express or standard?

1067