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 self join and what is the requirement of self join? : Sql dba
What is the location of pre_defined_functions.
explain mysql aggregate functions. : Sql dba
I have a table with 1 million records out of which 10,000 records are of unique records, then if I will implement index, then which type of index shall I use and why shall I use?
What is localdb mssqllocaldb?
What are the dml statements?
What do you understand by pl/sql cursors?
What is group function in sql?
What are different types of sql commands?
How can you load multi line records? : aql loader
what are the different type of sql's statements ? : Sql dba
What are the usages of sql?