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 will you distinguish a global variable with a local variable in pl/sql?

1093

---

Can unique keys be null?

853

---

Why is %isopen always false for an implicit cursor?

1037

---

What is sql prepared statement?

938

---

Does group by remove duplicates?

983

---

How many types of index are there?

962

---

Can we group by two columns in sql?

946

---

What are the types of sql commands?

1020

---

Is sql similar to python?

919

---

How delete all data from table in sql?

951

---

Is trigger a stored procedure?

887

---

Explain character-manipulation functions?

1070

---

What is the mutating table and constraining table?

969

---

How would you convert date into julian date format?

949

---

How to get help at the sql prompt?

1055

---