Answer Posted / meher

Let the table name is EMP

To find 101st row the query is as below:

select * from EMP where rownum <= 101
minus
select * from EMP where rownum <= 100;


for Nth salary the query is as below:

SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT
(DISTINCT (b.sal)) FROM EMP B WHERE a.sal<=b.sal);

What steps server process has to take to execute an update statement?

963

---

Can we join 3 tables in sql?

1004

---

What is spool?

1033

---

How do I save the results of sql query in a file?

963

---

How many clustered indexes can be created on a table?

1067

---

What does closing a cursor do?

1302

---

what is self join and what is the requirement of self join? : Sql dba

1122

---

List the various privileges that a user can grant to another user?

1032

---

how to see the create table statement of an existing table? : Sql dba

986

---

Which sorts rows in sql?

1000

---

How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?

1123

---

What is the difference between inner join and outer join?

973

---

Name some usages of database trigger?

1006

---

What is a unique key and primary key and foreign key?

955

---

What are different categories of sql commands?

1115

---