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

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

Question Posted / tamilarasan

6 Answers
8691 Views
I also Faced
E-Mail Answers

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 multiple columns?

1045

what are the join types in tsql? : Transact sql

1049

What is a temp table?

1002

What is difference between mysql and postgresql?

1120

What is schema in sql?

928

How do I save a sql query?

1001

What is the difference between distinct and unique in sql?

921

Can I copy :old and :new pseudo-records in/to an oracle stored procedure?

1195

What kind of join is join?

946

Which is faster view or stored procedure?

933

What are keys in sql?

980

Why do we need cursors in pl sql?

1059

What is using in sql?

1062

What are the types of dbms?

955

Are stored procedures faster than dynamic sql?

1019