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 are the 5 major parts of a database system?

897

---

What information can be stored in a database?

979

---

How do databases help businesses?

822

---

Define truncate and delete commands?

952

---

What is delimiter in dbms?

832

---

What is dbms and its advantages?

907

---

Enlist the cursor types.

986

---

What is concurrency control?

923

---

What is snow flake schema design in database? What's the difference between star and snow flake schema?

816

---

What is denormalization and why would someone consider doing so?

860

---

What is normalization and what are the different types of normalization?

925

---

What are the components of rdbms?

875

---

Is there an example how to configure udfaccess setting in firebird.conf?

905

---

Define union all operator and union.

874

---

How to prevent concurrent access to my data?

976

---