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 does a trigger work?

1144

---

How do you remove duplicate records from a table?

979

---

what is a unique key ? : Sql dba

1145

---

what is the difference difference between procedure and packages

10540

---

Can a table contain multiple foreign key’s?

1050

---

Is a table valued function object?

1076

---

How do you identify a primary key?

1113

---

column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

7484

---

What is trigger with example?

1169

---

Describe different types of general function used in sql?

1092

---

How is pl sql different from sql?

1142

---

Why do we need a foreign key?

1166

---

what is 'mysqlshow'? : Sql dba

1074

---

what are the advantages of using stored procedures? : Sql dba

1153

---

Define union, minus, union all, intersect ?

1064

---