I have a Employee table with columns ename,eid,salary,deptno. How to retrieve sum of salary for each deptno?

8 Answers   L&T,

---

Why we use stored procedure instead of query?

0 Answers  

---

Mention what are the benefits of pl/sql packages?

0 Answers  

---

Can we rename a column in the output of sql query?

0 Answers  

---

What is optimistic concurrency control? : Transact sql

0 Answers  

---

how to check the 3rd max salary from an employee table? One of the queries used is as follows: select sal from emp a where 3=(select count(distinct(sal)) from emp b where a.sal<=b.sal). Here in the sub query "select count(distinct(sal)) from emp b where a.sal<=b.sal" or "select count(distinct(sal)) from emp b where a.sal=b.sal" should reveal the same number of rows is in't it? Can any one here please explain me how is this query working perfectly. However, there is another query to get the 3rd highest of salaries of employees that logic I can understand. Pls find the query below. "select min(salary) from emp where salary in(select distinct top 3 salary from emp order by salary desc)" Please explain me how "select sal from emp a where 3=(select count(distinct(sal)) from emp b where a.sal<=b.sal)" works source:http://www.allinterview.com/showanswers/33264.html. Thanks in advance Regards, Karthik.

4 Answers  

---

What trigger means?

0 Answers  

---

How to fix oracle error ora-00942: table or view does not exist

0 Answers  

---

What is dba in sql? : SQL DBA

0 Answers  

---

please explain database architecture..

1 Answers   Infosys,

---

Store procedure will return a value?

4 Answers   eMids,

---

What are the return values of functions SQLCODE and SQLERRM ?

2 Answers   PreVator,

---