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 is a tablespace? : Sql dba

1052

What is composite primary key in sql?

996

How do I view stored procedures?

976

explain normalization concept? : Sql dba

1049

What is the example of procedure?

928

What does trigger mean in slang?

1058

What is the benefit of foreign key?

1022

How delete all data from all tables in sql?

946

Give the order of sql select?

1137

what is not null constraint? : Sql dba

1030

What are different joins used in sql?

1057

What is sql*plus?

1083

What are inbuilt functions in sql?

1065

Explain the difference between rename and alias?

1010

what is sp_pkeys? : Transact sql

1159