what are the differences between require and include, include_once and require_once? : Sql dba

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 is offset-fetch filter in tsql? : Transact sql

0 Answers  

---

hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews

0 Answers  

---

Which is better join or subquery?

0 Answers  

---

---

What is a string data type in sql?

0 Answers  

---

check whether all the emp numbers are indeed unique.

6 Answers  

---

What is partition by in sql?

0 Answers  

---

Create a procedure to delete certain records from a table and display the total number of records deleted in this process. (Condition for deletion can be of ur choice, for instance delete all records where eid='')

2 Answers  

---

What is pl sql quora?

0 Answers  

---

What does select count (*) mean in sql?

0 Answers  

---

What is sqlerrd?

0 Answers  

---