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

Name the operator which is used in the query for pattern matching?

891

Which table is left in join?

913

What is form and report?

925

What is snowflake sql?

1010

Is it possible to sort a column using a column alias?

990

Why is the cursor important?

974

How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?

1034

how can we take a backup of a mysql table and how can we restore it. ? : Sql dba

919

Can you call pl/sql package functions from within a fast formula?

973

What does <> sql mean?

984

Can we rollback delete command?

930

What is data profiling in sql?

1017

Why is sql better than hql?

920

Does truncate need commit?

889

What version is sql?

961