select page_no from book1 where page_no between 2 and 100 or page

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 / tarun

Answer Posted / tarun

select page_no from book1 where page_no between 2 and 100 or
page_no between 102 and 200

Is This Answer Correct ?

3 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are the types of variable use in pl sql?

741

What is the largest value that can be stored in a byte data field?

703

Which command is used to call a stored procedure?

709

Mention what are different methods to trace the pl/sql code?

746

Is left join faster than join?

758

discuss about myisam key cache. : Sql dba

757

Describe different types of general function used in sql?

724

What is dense_rank in sql?

690

What is composite primary key in sql?

707

Is not equal in sql?

752

Does sql support programming?

763

What is an example of translating a date into julian format?

773

What are the different types of constraints?

738

How can we make an if statement within a select statement?

733

Why do we need sharding?

724