OraFAQ Forum: Server Administration » sure this will work as per babu's view.

Home » RDBMS Server » Server Administration » sure this will work as per babu's view.

Mon, 05 March 2001 01:17

deva
Messages: 5
Registered: March 2001

Junior Member

select * from emp A where 10>= (select count(distinct(sal)) from emp where e.sal <= sal and ename like 'E%')

Previous Topic:	Re: who to search patterns ([0-9] or [a-z]) in sql
Next Topic:	Re: who to search patterns ([0-9] or [a-z]) in sql

Goto Forum:

]

Current Time: Sat Jun 29 13:43:18 CDT 2024