ميسا 260 ضروري

[هاوي غاوي]

في احد عنده اجابات ميسا 260
جبتر 7 ؟؟؟؟

 

[أسيرة ألأحلآآمـ]

1-SELECT *
FROM employee;

2- SELECT e_id,e_name,Sal
FROM employee
WHERE Sal>2oo ;

3- SELECT e_id,e_name
FROM employee
WHERE e-name like "*H";

4-SELECT e_id,e_name,deptno,Sal
FROM employee
WHERE deptno= 20 AND Sal< 200;

5- SELECT e_id,e_name,job
FROM employee
WHERE job =" Manager";

6- SELECT e_id,e_name
FROM employee
WHERE deptNO<>10;

7-SELECT E_id,e_name, job
FROM employee
WHERE deptno= (10,20,40);

8-SELECT [sal] + [Comm] AS net_income
FROM employee;

9-SELECT Avg (comm) AS Average_ commisions
FROM employee;

10-SELECT Sum(sal)
FROM employee
group by Deptno;



1- UPDATE employee SET Eid=128
WHERE e_id = 120;

2-UPDATE employee SET job = ''Typist"
WHERE job ="clerk";



1- DELET *
From employee
WHERE e_name = "Alan";


1-SELET Deptno,Dname,Ename
FROM DEPT INNER JOIN EMP ON Dept.deptno= EMP.deptno
WHERE job="Analyst";

2- SELET enum,ename,Dname FROM
emp INNER JOIN dept ON emp.deptno= dept.deptno
WHERE deptno=10;