about Oracle

tell me query of oracle
If we want to reterieve some data from a table whose salary is same take out their names like in Sql we have emp table reterive it from there