Answer Posted / shalina bajaj

select sal from emp a
where $number = (select count(distinct(sal))
from emp b
where a.sal <= b.sal);

What is error ora-01000: maximum open cursors exceeded

1151

---

How to find 3rd highest salary of an employee from the employee table in sql?

1083

---

How many types of triggers are there in pl sql?

1070

---

what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

1077

---

What is the difference between microsoft sql and mysql?

967

---

Are pl sql variables case sensitive?

1053

---

Differentiate between pl/sql and sql?

1155

---

What is write ahead logging in sql server?

1056

---

How do I view a sql trace file?

1035

---

List the ways to get the count of records in a table?

902

---

How is use pl and sql?

1068

---

Is sql developer case sensitive?

1005

---

What is sql select statement?

1038

---

What is a .db file?

992

---

What is a record in pl/sql?

1153

---