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

How do you create a blank database?

999

---

What are the different types of keys in database?

927

---

Which is the most used database?

986

---

What is system r?

1017

---

What are the examples of database management system?

917

---

What is database in simple language?

949

---

What is string in database?

927

---

What are the features of openedge features?

1077

---

what is normalization? types of normalization? example of each form? how do u implement normalization in ur project?

1910

---

Which parameters are optional in init.ora parameter file?

2271

---

How to use multiple database server in back end ?

1089

---

What is openedge rdbms?

1003

---

Why do not you use gnu autoconf or scons for building?

988

---

List few disadvantages of file processing system.

963

---

Write a query to remove duplicate rows from a table?

948

---