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 drop and truncate commands?
How many types of sql are there?
How do you modify a table in sql?
What is rename command in sql?
Why are indexes and views important to an organization?
what is a constraint? : Sql dba
Can we join 3 tables in sql?
What is primary key in db?
What is replication id?
Explain the difference between sql and mysql.
How do you delete a table?
What is the difference between having clause and where clause?
What is join view in sql?
How do I view a sql trace file?
How do you remove duplicates without using distinct in sql?