Hi, Can anybody please explain me the flow of the below query. I am not able to understand how this query works. This query is for finding the Nth highest salary.. SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT (DISTINCT (b.sal)) FROM EMP B WHERE a.sal<=b.sal); If N = 2 then second highest salary will be the o/p. If N = 3 then third highest salary will be the o/p. and so on.. Thanks, Nitin

5 Answers   Deloitte, Ness Technologies,

---

can i use dbms_output.put_line in a function u are telling as return statement

7 Answers  

---

Whate is use of MOD function in pl/sql.

3 Answers   Oracle,

---

what is self-join? : Sql dba

0 Answers  

---

What view means?

0 Answers  

---

What are the different operators available in sql?

0 Answers  

---

How do I run sql profiler?

0 Answers  

---

SELECT flavor, SUM (ice_cream_sales) FROM sales_detail GROUP BY flavor ORDER BY 2 DESC If the "sales_detail" table contains ten records with different values in the flavor column (two "vanilla," three "chocolate," four "strawberry," and one NULL), how many rows are returned by the sample code above? 1. 0 rows 2. 1 row 3. 3 rows 4. 4 rows 5. 10 rows

8 Answers   Sonata,

---

How many unique keys can a table have?

0 Answers  

---

what is inline view?

15 Answers  

---

When is the explicit cursor used ?

0 Answers  

---

What are the advantages of VIEW?

5 Answers  

---