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

In a distributed database system, can we execute two queries simultaneously?

750


What are all the ddl commands?

855


How show all rows in sql?

797


How do I view a procedure in sql?

723


Name some usages of database trigger?

746






What is the use of double ampersand (&&) in sql queries? Give an example

810


Cite the differences between execution of triggers and stored procedures?

823


what are the nonstandard string types? : Sql dba

803


What are different sql data types?

685


Why plvtab is considered as the easiest way to access the pl/sql table?

832


How many row comparison operators are used while working with a subquery?

753


what is a join? : Sql dba

768


What are the usages of sql?

752


How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?

1156


What is a table partition?

786