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 synonyms?

573


How can we make an if statement within a select statement?

543


How many commands are in sql?

525


What do you mean by stored procedures?

551


What is sql data?

552






Which version of sql do I have?

562


How to combine two stored procedures in sql?

591


How can you view the errors encountered in a trigger?

552


Explain the difference between sql and mysql.

567


Can you rollback after commit?

530


What is the difference between local variables and global variables?

612


How to raise user-defined exception with custom sqlerrm ?

682


Whis is not false in primary key?

977


Explain foreign key in sql?

621


does sql support programming? : Sql dba

611