krkolanu

 Profile Answers by krkolanu 

• Jul 8th, 2015

 

Code
SELECT a.empno,


  a.ename,


  a.deptno AS "DEPT ID",


  b.dname,


  COUNT(a.deptno) "COUNTS OF DEPT ID"


FROM scott.emp a,


  scott.dept b


WHERE a.deptno = b.deptno


GROUP BY a.empno,


  a.ename,


  a.deptno,


  b.dname


ORDER BY a.deptno;

vinay

• Jul 9th, 2015

 

Code
SELECT deptno, count(deptno)


FROM emp


GROUP BY deptno;

vinay

• Jul 11th, 2015

 

Code
 


SELECT a.empno,


a.ename,


a.deptno AS "DEPT ID",


b.dname,


COUNT(a.deptno) over (partition BY a.deptno ORDER BY 1) count_dept


FROM scott.emp a,


scott.dept b


WHERE a.deptno = b.deptno

Abhilash Choudhary

• Oct 5th, 2015

 

Code
SELECT E.Empno, E.Ename, E1.Deptno, E1.Leastsal


FROM Emp E,(SELECT Deptno,COUNT(Deptno) Leastsal


                    FROM Emp 


                    GROUP BY Deptno) E1


WHERE E.Deptno = E1.Deptno


ORDER BY Deptno

Preetish

• Dec 23rd, 2015

 

Code
SELECT d.dept_name , count(e.emp_no) 


FROM dept d,emp e


WHERE d.dept_no=e.dept_no


GROUP BY d.dept_no;

M JAGADADEESH

• Mar 9th, 2016

 

Code
SELECT DEPTNO,COUNT(EMPNO) FROM EMP GROUP BY DEPTNO

sumanamara2016

 Profile Answers by sumanamara2016 

• Mar 18th, 2016

 

Code
WITH EMP2 AS(


   SELECT DEPTNO,COUNT(*) LASAL


    FROM EMP


    GROUP BY DEPTNO)


SELECT E.EMPNO,E.ENAME,E.DEPTNO,E2.LASAL


 FROM EMP E ,(SELECT * FROM EMP2) E2


WHERE E.DEPTNO = E2.DEPTNO ORDER BY E.DEPTNO;


 


7782    CLARK   10      3


7839    KING    10      3


7934    MILLER  10      3


7566    JONES   20      5


7902    FORD    20      5


7876    ADAMS   20      5


7369    SMITH   20      5


7788    SCOTT   20      5


7521    WARD    30      6


7844    TURNER  30      6


7499    ALLEN   30      6


7900    JAMES   30      6


7698    BLAKE   30      6


7654    MARTIN  30      6