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

can anyody please send me the dump for Oracle 10g certifications for DBA path?

1793


What is dual table oracle?

605


What are the database administrators utilities available?

662


What are the differences between date and timestamp in oracle?

653


What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.

635






How to drop a tablespace?

656


Can we write insert statement in function in oracle?

653


How to use "startup" command to start default instance?

635


How to use "in out" parameter properly?

695


Difference between open_form and call_form in oracle.

786


What is not equal to in oracle?

645


What is the difference between substr & instr functions?

695


Explain the use of record option in exp command.

628


What is merge in oracle?

648


what is the difference between restoring and recovering?

630