Home » SQL & PL/SQL » SQL & PL/SQL » range search
range search [message #897] Mon, 11 March 2002 19:17 Go to next message
krishna
Messages: 141
Registered: October 1998
Senior Member
I want to retrieve the data of an employee in my emp table. I know that this employee exists between the employee numbers 2000 and 2100. How can i force oracle to look for employees betweeen 2000 and 2100?

Report message to a moderator

Re: range search [message #906 is a reply to message #897] Tue, 12 March 2002 03:43 Go to previous message
sfhollands
Messages: 15
Registered: October 2001
Junior Member
use the BETWEEN condition

select * from emp where empno between 2000 and 2100;

Report message to a moderator

Previous Topic: LOV Problem
Next Topic: help in simple sql statement
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 05:27:01 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.