-
SQL Query to find the department (ID) wise counts in the company
Write SQL Query to find the department (ID) wise counts in the company. Schema "employee" contains "employee_id", "employee_name", "dept_id".
-
How to retrieve 2nd highest sal in each departement from emp and dept tables using GROUP BY?
EMP table (empno,deptno,sal) DEPT table(deptno,dname) i need Deptno, Dname, 2nd_highest_sal_in_dept in output. I can easily do this using row_number, Rank,Dense_rank etc but I am unable to do this using Group By. Please suggest if this can be done using Group By.
-
Truncate and Delete concept
Hi, Let us take a scenario such that I issue a delete on table emp and truncate on table emp1 which is exact replica (in terms of both structure and data) of emp table.Now , I issue a commit on both sessions. If I do a select * from emp and select * from emp1 now, which one should execute faster and why?
-
Display Middle Record
How to display middle record in a given table?
-
-
-
What is the purpose of a cluster?
Oracle does not allow a user to specifically locate tables, since that is a part of the function of the RDBMS. However, for the purpose of increasing performance, oracle allows a developer to create a CLUSTER. A CLUSTER provides a means for storing data from different tables together for faster retrieval than if the table placement were left to the RDBMS.