suppose u hav 1 book with set...page 1-100 n 101 -200 now print page from 2-10

Categories >> Software >> Databases >> SQL PLSQL
Suggest New Category

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 / ankitkumar9999

6 Answers
8933 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

suppose u hav 1 book with set...page 1-100 n 101 -200 now print page from 2-100 n 102 -200... how..

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

Is This Answer Correct ?

4 Yes

0 No

suppose u hav 1 book with set...page 1-100 n 101 -200 now print page from 2-100 n 102 -200... how..

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

Is This Answer Correct ?

4 Yes

1 No

suppose u hav 1 book with set...page 1-100 n 101 -200 now print page from 2-100 n 102 -200... how..

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?

Is This Answer Correct ?

4 Yes

1 No

suppose u hav 1 book with set...page 1-100 n 101 -200 now print page from 2-100 n 102 -200... how..

Answer / 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

suppose u hav 1 book with set...page 1-100 n 101 -200 now print page from 2-100 n 102 -200... how..

Answer / ankit

@ Tamilarasan

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

Is This Answer Correct ?

0 Yes

0 No

suppose u hav 1 book with set...page 1-100 n 101 -200 now print page from 2-100 n 102 -200... how..

Answer / ankit

@Tamilarasan

thanks working.....-)

Is This Answer Correct ?

0 Yes

0 No

Post New Answer