SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
--Select table_name from all_tables; select * from employee; select * from department; /*create view stuvu10 as select id_stu,f_name as name,s_name from student2 where fac_id = 2; select* from stuvu10;*/ create or replace view stvu20 (dept_name,min_sal,max_sal,avg_sal) as select d.dept_name, min(e.salary),max(e.salary), avg(e.salary) from employee as e Join department as d on (e.id = d.id) group by d.dept_name; --select * from stvu20;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear