-
SQL - Find top two salary for each department
1. top 2 salary in each dept2. 2nd maximum sal in each dept3. 2nd minimum sal in each dept.
Prasanth
- Sep 12th, 2022
SELECT d.department_id, d.salary, d.employee_id FROM
(SELECT employee_id, department_id, salary, dense_rank() over(partition by department_id order by salary desc ) as salary_DenseRank from employees) d
WHERE d.salary_DenseRank =2;ashadevi21
- Sep 27th, 2011
The Same can be modified and can be used for 2nd maximum and 2nd minimum as well For 2nd Maximum =========== SELECT dept_id, salary FROM (SELECT dept_id, salary ...
-
Single Row Function
Display details of employees having same char at the star and end postition of their namelike abishikathis name have last character and first character is same
yuvaevergreen
- Jun 8th, 2011
In Teradata,sel * from employee where substr(name,1,1)=substr(name,length(trim(name)),1)
Miao Lin
- May 9th, 2011
SELECT * from employee where SUBSTR(EmployeeName, 1,1) = SUBSTR(EmployeeName, -1,1);
-
What is reference cursor?
sandyl2
- Jun 22nd, 2011
A Normal Currsor is like a Constant but RefCursor is a Variable. RefCursor is a Dynamic Cursor. Main Advantage of RefCursor is same Cursor can be associated with different Select Statements.
