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;

find the second highest salary of the emp table

6 Answers  

---

What is a cluster Key ?

2 Answers  

---

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

0 Answers  

---

how the indexes are stored in the Oracle Database?

0 Answers  

---

dear sir/madam, i have done my engg in 2007 after that i did oracle course (sql,plsql,forms,reports) .from 2008 to 2009 i searched job but didnt got.so i planned to move to sales field & i gone to dubai.till now i m in sales only.now i want to shift my career in to IT industry.but now people are not hiring as fresher.so i planned put fake 1 + exp. is it good or bad or any other way is there to enter in IT.please suggest me or call me 09632087338.

3 Answers  

---

How to use fetch statement in a loop?

0 Answers  

---

What is a Database instance ? Explain?

3 Answers  

---

"primary key=unique+null" is equal,reson?not,reason?

5 Answers  

---

How to use select statement to count the number of rows in oracle?

0 Answers  

---

You have one employee table having 3 entries emp_id, Mgr_id and salary. Mgr_id is also referencing emp_id. so now find out the emp_id which are having the second highest salary, under a particular manager.

3 Answers   Amazon, HCL,

---

when loggined as SYSTEM,how to display all the users of database using sql query?

2 Answers  

---

State and explain about oracle instance?

0 Answers  

---