how to comparison with another attr not use subquery in oracle sql

Question

there is two attr about workers.

name: worker's name, worth : worker's worth

i want to comparison worker's worth more than mike'worth

select w1.name
from worker w1, worker w2
where w1.worth>w2.name='mike'.worth ///???

i want to know how i write code in where phrase

Answer 1

The 'WHERE' clause is used to filter records. It is used to extract only those records that fulfill a specified condition. The comparison can be of similar data types only. You can compare or put in condition for comparison of
name to name

worth to worth

but notnametoworth.