Answer Posted / rajat

SELECT * FROM (
SELECT RANK()OVER( ORDER BY SALARY DESC) NUM, A.* FROM RAJ A)
WHERE NUM=2;

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

926

---

What is lexical units in pl sql?

1052

---

In a distributed database system, can we execute two queries simultaneously?

992

---

How does sql store data?

866

---

What is query syntax?

913

---

which operator is used in query for pattern matching? : Sql dba

947

---

Can a primary key be a foreign key?

969

---

How does sql*loader handles newline characters in a record? : aql loader

985

---

How do you know if a relationship is 2nf?

877

---

What is the usage of nvl function?

982

---

how many values can the set function of mysql take? : Sql dba

933

---

What is the difference between mdf and ndf files?

1061

---

1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...

2365

---

How can you create an empty table from an existing table?

1010

---

How do I pipe the output of one isql to another?

944

---