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

Say you have table with column "page_no" starts from 1 to
200.

Run the below query to get the desired answer

select page_no from book1 where mod(page_no,100) != 1

Is This Answer Correct ?    4 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is Collation Sensitivity ? What are the various type ?

493


What are sql injection vulnerabilities?

493


What is coalesce sql?

509


what are the disadvantages of mysql? : Sql dba

562


What is record type in pl sql?

534






What does dml mean?

541


What is trigger price?

533


Is it possible to create startup or shutdown trigger for on-schema?

577


What is the use of partition by in sql?

508


How can you select unique records from a table?

512


How to connect a sql*plus session to an oracle server?

613


Explain the uses of control file.

606


What is varchar data type in sql?

512


What types of commands can be executed in sql*plus?

542


How do you write an inner join query?

503