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...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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..?

Question Posted / tamilarasan

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

What is mutating table error?

1183

What is clustered and nonclustered index in sql?

944

What are the different operators available in sql?

1001

what is innodb? : Sql dba

1106

How do you bind variables in pl sql?

1097

What does count (*) mean?

934

what are the different index configurations a table can have? : Sql dba

997

What are the types of views in sql?

1103

Mention what plvcmt and plvrb does in pl/sql?

1143

Can we rollback after truncate?

1031

How to know the last executed procedure?

1099

What is an exception in PL/SQL? What are the two types of exceptions?

1312

what are the type of locks ? : Sql dba

966

What is pragma in sql?

1082

What is the most important ddl statements in sql are?

997