For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
I need to select minimum salary within each department. Please find scripts below.
create table emp
( id number,
dept_no number,
salary number);
insert into emp values(1,10,'2000,1000,3000');
insert into emp values(2,20,'3000,1500,6000');
Thanks.