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.....-)

Dear All, Question for this Week Find out possible error(s) (either at compile time or at runtime) in the following PL/SQL block. State the reason(s) and correct the errors. Declare Cursor C1 is select ename, sal, comm from emp; Begin For i in C1 Loop If i.comm between 299 and 999 then Dbms_output.put_line(i.Ename || ‘ ** Good Commission’); Elsif i.comm > 999 then Dbms_output.put_line(i.Empno || ‘ ** Very Good Commission’); close C1; Else Dbms_output.put_line(i.Ename || ‘ ** ’ ||nvl(i.comm,‘O’)); End if; End Loop; End;

7 Answers   Accenture,

Is sql considered coding?

0 Answers  

Can instead of triggers be used to fire once for each statement on a view?

0 Answers  

what is meant by forward declaration in functions?

4 Answers   TCS,

What is the use of pl/sql table?

0 Answers  

How do you delete a table?

0 Answers  

what is the difernece between named and anonymous pl/sql blocks??

8 Answers   TCS, Wells Fargo,

SELECT category, type, AVG(price) FROM products GROUP BY category, type ORDER BY 1, 2 If there are three distinct categories in the "products" table, and each one has five different types, how many rows are returned by the query above? 1. 1 row 2. 3 rows 3. 5 rows 4. 8 rows 5. 15 rows

3 Answers  

How many types of functions are there in sql?

0 Answers  

What is PL/SQL Records?

0 Answers  

HOW CAN I FIND MAX SAL ,ENAME FROM EMP TABLE.

16 Answers  

what is meant by databases

4 Answers