what is the difference between binary_integer and pls_integer

2 Answers   TCS,

---

what is the command for user data type?

2 Answers  

---

In testing where do we use sql language and how it helps in testing?

2 Answers  

---

What is the difference between a query and a report?

0 Answers  

---

What are the types of queries in 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 is a tablespace? : Sql dba

0 Answers  

---

What are the PL/SQL Statements used in cursor processing ?

4 Answers  

---

In table three columns with 1 milion records(here there is no sequence values) i want add one more column with sequence values from the first how it is posible?

4 Answers   Tech Soft,

---

What information is needed to connect sql*plus an oracle server?

0 Answers  

---

What is a left join?

0 Answers  

---

Which column of the user triggers data dictionary view displays the database event that will fire the trigger?

0 Answers  

---