Answer Posted / nitin tomer

Query without using analytic function:

SELECT dept_id, MAX(salary)
FROM EMPLOYEE_DEPT WHERE rowid NOT IN (SELECT MAX(rowid) FROM EMPLOYEE_DEPT GROUP
BY dept_id )
GROUP BY dept_id
UNION
SELECT dept_id, MAX(salary)
FROM EMPLOYEE_DEPT
GROUP BY dept_id;

using row_number() function:

SELECT NAME,DEPT_ID,SALARY,RNM FROM
(SELECT NAME,DEPT_ID,SALARY,ROW_NUMBER()OVER(PARTITION BY DEPT_ID ORDER BY SALARY DESC) AS RNM
FROM EMPLOYEE_DEPT)WHERE RNM<3;

How do I edit a stored procedure?

992

---

Can pl sql procedure have a return statement?

1030

---

What is the trigger in sql?

953

---

What is sorting in sql?

942

---

Explain the significance of the & and && operators in pl sql.

1009

---

hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews

2014

---

How can we implement rollback or commit statement in a trigger?

1034

---

What is dense_rank in sql?

986

---

Is sql similar to python?

970

---

What are the differences between in and exists clause?

1111

---

Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

2111

---

Is oracle and sql same?

1007

---

How to use transactions efficiently : transact sql

1058

---

What is relationship? How many types of relationship are there?

1181

---

How do I run a sql trace?

957

---