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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

3109


Is delete faster than truncate?

547


how tsql statements can be written and submitted to the database engine? : Transact sql

534


what are the different functions in sorting an array? : Sql dba

581


What is meant by truncate in sql?

524






What is pl sql block in dbms?

528


How long it takes to learn pl sql?

533


Does asenumerable execute the query?

603


Is and as keyword in pl sql?

513


What is %rowtype in pl sql?

513


What is the difference between python and sql?

524


What is information schema in sql?

580


What is group function in sql?

539


what is a trigger in mysql? Define different types of trigger. : Sql dba

552


What is pl/sql language case sensitive?

635