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 many columns should be in an index?

969

Write a query to find the names of users that begin with "um" in sql?

1009

What are sql constraints?

1187

What are the two characteristics of a primary key?

996

What is field delimiter?

1055

What is the difference between having and a where in sql?

1115

what is a trigger? : Sql dba

1042

how many groups of data types? : Sql dba

1040

Why do we create views in sql?

1163

When you have to use a default "rollback to" savepoint of plvlog?

1211

How to process query result in pl/sql?

1143

what is query cache in mysql? : Sql dba

1050

How do you update a sql procedure?

1037

Which column of the user triggers data dictionary view displays the database event that will fire the trigger?

1033

what is the difference between char_length and length? : Sql dba

1058