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..?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
what is a scheduled jobs or what is a scheduled tasks? : Sql dba
Why is theta join required?
how can we know the count/number of elements of an array? : Sql dba
what is 'trigger' in sql? : Sql dba
What is the difference between UNIQUE CONSTRAINT and PRIMARY KEY? 1. There is no difference. 2. A PRIMARY KEY cannot be declared on multiple columns. 3. A UNIQUE CONSTRAINT cannot be declared on multiple columns. 4. A table can have multiple PRIMARY KEYS but only one UNIQUE CONSTRAINT. 5. A table can have multiple UNIQUE CONSTRAINTs but only one PRIMARY KEY.
Explain raise_application_error.
How do I run a sql script?
What is the difference between python and sql?
What is range partitioning?
Why does sql need a server?
What is sql injection owasp?
Can we edit a view in sql?