1

Topic: Sampling of records in the line, lines having a certain amount

Colleagues, a question trivial:
Prompt, please, function which helps to select only those lines record in which contains from 5 to 7 signs

2

Re: Sampling of records in the line, lines having a certain amount

Litwa;

select * from scott.emp where length (ename) between 5 and 7;

3

Re: Sampling of records in the line, lines having a certain amount

RTFM SQL Functions (FAQ)

4

Re: Sampling of records in the line, lines having a certain amount

Elic, thanks!

5

Re: Sampling of records in the line, lines having a certain amount

orawish;
Thanks big!

6

Re: Sampling of records in the line, lines having a certain amount

orawish wrote:

select * from scott.emp where length (ename) between 5 and 7;

And who here record, and who lines?