Display the records between two range?

Answer Posted / basanti

select * from emp where emp_id between '200' and '300'

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Difference between varchar and varchar2 data types?

656


Give syntax for SQL and ORACLE joins.

626


How to open a cursor variable?

601


Why packages are used in oracle?

533


What are dml statements in oracle?

613






How to synchronize 2 schema's objects?

1682


What privilege is needed for a user to query tables in another schema?

502


What is the maximum number of triggers that can be applied to a single table?

551


Respected sir, Please send me technical questions related to oracle apps..

1369


You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

1451


What is MTTR advisor in Oracle?

601


What is an Oracle Instance?

682


How can I introduce multiple conditions in like operator?

546


What do you mean by cdb and pdb in oracle 12c?

633


What happens to the data files if a tablespace is dropped?

570