Answer Posted / nikhilesh roy

WITH
CTE as
(select emp_id,salary,rn=row_number() over (order by salary desc) from emp_table )
select * from CTE where rn=3;

What is error ora-01000: maximum open cursors exceeded

1146

---

What are the two types of exceptions.

1168

---

ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

2497

---

what is commit? : Sql dba

1073

---

How many types of normalization are there?

963

---

Why we use stored procedure instead of query?

998

---

what is the difference between a web-garden and a web-farm? : Sql dba

1081

---

Is postgresql a nosql database?

1160

---

What are the types of queries in sql?

1086

---

How does stored procedure reduce network traffic?

1008

---

What is difference between sql function and stored procedure?

1003

---

What is an index? What are the types of indexes? How many clustered indexes can be created on a table?

1075

---

What is pl sql code?

1053

---

How many types of functions are there in sql?

955

---

How show all rows in sql?

1013

---