OraFAQ Forum: Server Administration » how to retrive data starts from Aa till Am from a table?

Home » RDBMS Server » Server Administration » how to retrive data starts from Aa till Am from a table?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to retrive data starts from Aa till Am from a table? [message #373181]

Mon, 02 April 2001 13:53

Senthil
Messages: 68
Registered: December 1999

Member

how to retrive data whose value starts from Aa till Am

Report message to a moderator

Re: how to retrive data starts from Aa till Am from a table? [message #373188 is a reply to message #373181]

Tue, 03 April 2001 04:58

John R
Messages: 156
Registered: March 2000

Senior Member

Select {fields}
From {Table}
where substr(column,1,2) between 'Aa' and 'Am'

Report message to a moderator

Re: how to retrive data starts from Aa till Am from a table? [message #373200 is a reply to message #373181]

Tue, 03 April 2001 23:11

Naresh
Messages: 27
Registered: March 2001

Junior Member

Solution :

select * from

where <column_name> like 'Aa%'
or <column_name> like 'Am%';

---------------------
If based on emp table, can be written as:

select * from emp
where ename like 'Aa%'
or ename like 'Am%';

--------------------

Report message to a moderator

Previous Topic:	Re: How I can take avg of last 3 months
Next Topic:	how to count no. of columns in a table??

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jun 29 01:12:55 CDT 2024