Answer Posted / rishab

select emp_name,salary,rownum from
(select emp_name,salary,r from
(select salary,emp_name,rownum r from
(select salary,emp_name,rownum
from emp
order by salary desc)
order by r)
where r<4 ---- this number must be n+1
order by salary)
where rownum=1;
-- yes rownum=1 works...

What is the starting oracle error number? What is meant by forward declaration in functions?

978

---

What do you mean by field in sql?

1072

---

What is compiled query?

1019

---

Can we rename a column in the output of sql query?

981

---

Show the cursor attributes of pl/sql.

1031

---

What does count (*) mean?

912

---

What sql does db2 use?

966

---

Does inner join return duplicate rows?

962

---

What are the two different parts of the pl/sql packages?

1071

---

what are set operators in sql? : Sql dba

1028

---

Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

2104

---

Explain what is table in a database?

1048

---

What is a database trigger?

1051

---

Is pl sql different from sql?

971

---

How consistent is the view of the data between and within multiple sessions, transactions or statements ?

2211

---