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;

Can u make a synonym for deptno=10 only from emp table.

1 Answers   TCS,

---

How to turn on or off recycle bin for the session?

0 Answers  

---

What is enter substitution variable in oracle?

0 Answers  

---

How can we find out the duplicate values in an oracle table?

0 Answers  

---

How to empty your oracle recycle bin?

0 Answers  

---

---

Is it possible to insert comments into sql statements return in the data model editor ?

0 Answers   Oracle,

---

What are Schema Objects ?

2 Answers  

---

What is bulk copy or bcp in oracle?

0 Answers  

---

Explain the statement?? ALTER TABLE TABLE_NAME MOVE; What it the use of above statement??

1 Answers   BirlaSoft,

---

interview questions with answer for cts

0 Answers   Cognizant,

---

find the second highest salary of the emp table

6 Answers  

---

how to select second mauximum value in a given table under salary column

6 Answers   Sapient,

---