Answer Posted / shailesh j

SELECT * FROM (
SELECT DEPARTMENT_ID,SALARY,DENSE_RANK() OVER(PARTITION BY
DEPARTMENT_ID ORDER BY SALARY DESC) AS RK FROM EMPLOYEES)
WHERE RK<4;

Why is theta join required?

1149

---

Differentiate between pl/sql and sql?

1155

---

What is the difference between stored procedure and view?

1021

---

i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

1582

---

What are the types of index in sql?

1071

---

Can sql developer connect to db2?

1056

---

How many columns should be in an index?

963

---

What is number function in sql?

980

---

Why do we use sql constraints?

1175

---

What is the non-clustered index in sql?

1066

---

What is package in pl sql with an examples?

1041

---

What is cross join sql?

924

---

How to write pl sql program in mysql command prompt?

1102

---

Is sql low level language?

1023

---

Enlist the characteristics of pl/sql?

1806

---