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 are the advantages of using stored procedures? : Sql dba

1106

---

What is compilation error in pl sql?

985

---

What is type and rowtype in pl sql?

1021

---

What is a design view?

932

---

How many unique keys can a table have?

1020

---

How to run sql commands in sql*plus?

1189

---

How many types of cursors are available in pl/sql?

1112

---

What is the use of sqlerrd 3?

945

---

What are the different types of triggers?

1139

---

How does sql developer connect to oracle database?

1007

---

What is a record in a database?

1068

---

How do I remove sql developer from windows 10?

1117

---

How many subqueries can be nested in a statement?

992

---

What is sql trigger example?

1071

---

What does fetching a cursor do?

1096

---