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

Which join is like an inner join?

1095

What is the use of procedures?

1017

Is truncate ddl or dml?

1038

Why use truncate instead of delete?

1074

Is trigger a stored procedure?

984

How do you respond to dementia behavior?

1016

Are null values same as that of zero or a blank space?

1073

How does sql developer connect to oracle database?

1051

What are the benefits of pl/sql packages?

1161

Explain the difference between triggers and constraints?

1025

Can a foreign key be a duplicate?

967

What is function and procedure in pl sql?

1120

Which are the different character-manipulation functions in sql?

1113

What is primary key sql?

1112

What is on delete set null?

1137