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 type of database is sql?

771


can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba

757


How many types of indexes are there in sql?

705


What are the key differences between SQL and PL SQL?

849


Can we commit in trigger?

696






how to increment dates by 1 in mysql? : Sql dba

719


How to convert comma separated string to array in pl/sql?

806


How is data stored in sql?

720


Why do we need sharding?

723


What are pl sql data types?

724


how to fetch common records from two tables? : Sql dba

838


What is the difference between partitioning and sharding?

725


How global cursor can be declare with dynamic trigger ?

1935


Can we create index on primary key?

712


How do I run a pl sql procedure in sql developer?

690