Answer / rajesh venati

Actually i didn't get u r question exactly, As per above
question, it will also work

select page_no from book where page_no not in(1,101);

Answer / tamilarasan

Say you have table with column "page_no" starts from 1 to
200.

Run the below query to get the desired answer

select page_no from book1 where mod(page_no,100) != 1

Answer / tamilarasan

If you run this query select page_no from book1 where mod
(page_no,100) != 1

in a single column u will get the page nos as follows

RESULT
-------
2.
...
100
102
...
200

Is this the one you want?

Answer / tarun

select page_no from book1 where page_no between 2 and 100 or
page_no between 102 and 200

Answer / ankit

@ Tamilarasan

i wann to display both set of pages in single query...( i m
new in SQL...ONLY 2 MONTH exp.)

Answer / ankit

@Tamilarasan

thanks working.....-)

What is the basic form of sql query?

0 Answers  

can we create index on index?

7 Answers   iFlex, Symphony,

Can we use ddl statements in stored procedure?

0 Answers  

What is the maximum number of triggers, you can apply on a single table?

0 Answers  

What is pl sql collection?

0 Answers  

How to call DDL statements from pl/sql?

5 Answers  

how many groups of data types? : Sql dba

0 Answers  

Explain lock escalation? : Transact sql

0 Answers  

Why do we use partitions in sql?

0 Answers  

What are functions in sql?

0 Answers  

How can i insert data inro a table with 3 columns using FORALL?

2 Answers   Oracle,

List the ways to get the count of records in a table?

0 Answers