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..?
- 6 Answers
- 7776 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Can we use join in subquery?
What is a boolean in sql?
What is server name sql?
Which operator is used in query for pattern matching?
What is a join query?
Is it possible to link two groups inside a cross products after the cross products group has been created?
What are % type and % rowtype?
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
How many sql statements are used?
What is equi join in sql?
What is the use of <> sql?
Which data type is a composite type?
What plvcmt and plvrb does in pl/sql?
define join and explain different type of joins? : Sql dba
What is the advantage of nosql?
