SQLcreatetableemp(idnumber,namevarchar2(10),salarynumber);Tablecreated.SQLinsertintoempvalues(1,\'aaa\',1000);1rowcreated.SQLinsertintoempvalues(2,\'bbb\',2000);1rowcreated.SQLinsertintoempvalues(3,\'ccc\',3000);1rowcreated.SQLinsertintoempvalues(4,\'ddd\',4000);1rowcreated.SQLselectid,name,salaryfromemp,(selectavg(salary)avsfromemp)avwhereemp.salaryav.avs;IDNAMESALARY------------------------------3ccc30004ddd4000赞同
|
