Answer Posted / srinu

SELECT * FROM EMP WHERE SAL=(SELECT MIN(SAL) FROM ( SELECT
DISTINCT(SAL) FROM EMP ORDER BY SAL DESC) WHERE ROWNUM<'&N');

ANS::

EMPNO ENAME JOB MGR HIREDATE SAL
COMM DEPTNO
------ ---------- --------- ---------- --------- ----------
---------- ----------
7566 JONES MANAGER 7839 02-APR-81 2975
20

SELECT * FROM EMP WHERE SAL=(SELECT MIN(SAL) FROM ( SELECT
SAL FROM EMP ORDER BY SAL DESC) WHERE ROWNUM<'&N');



EMPNO ENAME JOB MGR HIREDATE SAL
COMM DEPTNO
------ ---------- --------- ---------- --------- ----------
---------- ----------
7788 SCOTT ANALYST 7566 19-APR-87 3000
20
7902 FORD ANALYST 7566 03-DEC-81 3000
20

what do u mean by canvases and alerts?

2052

---

what are the different levels of database schema?

1167

---

What exactly is a database?

929

---

What are new features postgre 9.1?

1026

---

Explain 4nf?

1032

---

How can I create database in excel?

958

---

What are the properties of a primary key in DBMS?

999

---

What is database url?

1033

---

How do you exit a database?

938

---

What does fill factor concept mean with respect to indexes?

966

---

Explain what is a deadlock and mention how it can be resolved?

928

---

Define join and enlist its types.

1143

---

What do you understand by fragmentation?

964

---

What you mean by Object Relational DBMS?

1105

---

How do you create a blank database?

992

---