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

how to calculate the difference between two dates? : Sql dba

1043

How do you respond to dementia behavior?

956

what is the difference between where clause and having clause? : Sql dba

985

What is transaction control language (tcl)?

1116

What is the use of index in hive?

990

What is sql and how does it work?

1150

Why is nosql good?

1006

How do I count duplicates in sql?

1085

Does db2 use sql?

923

Determine if oracle date is on a weekend?

1026

What is difference between cursor and trigger?

1055

What is a delimiter in sas?

1035

What are different types of statements supported by sql?

1147

What is raw datatype in sql?

1029

What happens when a trigger is associated to a view?

896