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 / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is java sql driver?

536


Differentiate between sga and pga.

663


How to run sql statements through the web interface?

503


What is parameter substitution in sql?

519


What are the types of views in sql?

532






What is synchronized subquery?

585


how to get a list of indexes of an existing table? : Sql dba

508


What is the maximum number of columns in sql table?

541


In what condition is it good to disable a trigger?

548


What is the cause of mutating table error and how can we solve it?

592


why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba

552


What is primary key secondary key alternate key candidate key?

536


What is the basic form of sql query?

486


Does asenumerable execute the query?

591


What is %type in pl sql?

536