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..?
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
what is the difference between cluster and non cluster index? : Sql dba
What schema means?
Explain the rollback statement?
What is AUTH_ID and AUTH_USER in pl/sql ?
What is pivot in sql?
What is the sql query to display the current date?
What are the differences between in and exists clause?
what is a field in a database ? : Sql dba
Is there a way to automate sql execution from the command-line, batch job or shell script?
what is isam? : Sql dba
What is the sql*loader? : aql loader
What is normalization? How many normalization forms are there?
What is a dynamic query?
What is database migration?
What is the source code of a program?