What is asqueryable?

0 Answers  

---

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,

---

When we give SELECT * FROM EMP; How does oracle respond?

24 Answers   Accenture, HCL, Infosys,

---

What is record variable?

0 Answers  

---

i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

0 Answers  

---

---

How long does it take to learn pl sql?

0 Answers  

---

What is the use of cursor ? how cursor allocate context area for executing the sql statement?

4 Answers   HCL,

---

What are the different types of joins and explain them briefly.

3 Answers  

---

Is sql between inclusive?

0 Answers  

---

how many sql dml commands are supported by 'mysql'? : Sql dba

0 Answers  

---

how to create user in sql and how to set password for that?

3 Answers  

---

what are the differences between char and nchar? : Sql dba

0 Answers  

---