What is an exception in PL/SQL? What are the two types of exceptions?

0 Answers  

---

how to select unique records from a table? : Sql dba

0 Answers  

---

Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?

0 Answers  

---

Why do we use sqlite?

0 Answers  

---

Write a sql query to convert all character to uppercase after hypen.

0 Answers  

---

How to get list of all tables from a database?

0 Answers  

---

How can you select unique records from a table?

0 Answers  

---

scope of exception handling in plsql

4 Answers   Wipro,

---

I have a table .in the table 100 recored is there .we have get the single row with out using clause..

3 Answers  

---

How delete all data from all tables in sql?

0 Answers  

---

How the execution will be done in exceptions?

2 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  

---