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
This conversation is currently closed to new comments.
This is a hard question to assertain the meaning ofit. Has this question been submitted for inclusion on the OCP?
If I read this correctly the points missed by the previos two are that a GROUP BY is required to match up employees with the same SALARY. I will add an ORDER BY to make then a little neater.
SELECT name FROM EMP ORDER BY SALARY GROUP BY SALARY;
or if you want to retrieve rows from a table that have a common value but you don't know this value: select name, salary from emp where salary in (select salary from emp group by salary having count(*) > 1) order by salary, name;
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
about 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