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 is advantage of dbms?

1011

---

What is meant by database system?

903

---

What is Schema in DBMS?

1060

---

What is data model example?

1035

---

Why do we need database?

905

---

What do you understand by database triggers?

929

---

Explain a join between tables?

1043

---

Is the server accepting tcp ip connections on port 5432?

889

---

What are the objectives of rdbms?

906

---

List few ways to code transactions in an efficient manner?

920

---

Define database system.

961

---

Who is the founder of database?

1109

---

Mention the differences between union and union all

919

---

What is normalization in database with example?

909

---

Explain armstrong rules? How they are complete and/or sound?

897

---