Answer / manoj

SELECT employee_id, employee_name, salary FROM employees
where rownum < 6 ORDER BY
salary DESC
group by department_id;

Answer / lakshya

SELECT salary FROM employee where rownum < 6 ORDER BY
salary DESC
group by dept;

what is the difference between sql& oracle?

11 Answers   Oracle,

---

What is the difference between a primary key & a unique key?

0 Answers  

---

Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?

0 Answers  

---

Select the Nth lowest value from a table?

4 Answers  

---

How to assign values to data fields in record variables?

0 Answers  

---

How to define default values for formal parameters?

0 Answers  

---

Explain how you would restore a database using RMAN to Point in Time?

0 Answers  

---

How to drop an index in oracle?

0 Answers  

---

Define 'view' advantage ?

2 Answers   AZTEC, TCS,

---

How to use windows user to connect to the server?

0 Answers  

---

Whether any commands are used for months calculation? If so, what are they?

0 Answers  

---

What is data block in Oracle?

0 Answers   MCN Solutions,

---