Answer Posted / shalina bajaj

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

Can we use pl sql in mysql?

1063

---

What is keys and its types?

1121

---

Are sql connections encrypted?

1085

---

What are the operators in sql?

1067

---

What is difference between stored procedures and application procedures?

1063

---

Can we insert data into materialized view?

990

---

What is nvarchar max in sql?

1072

---

Which is faster joins or subqueries?

1035

---

What are the types of variables use in pl sql?

1089

---

What is the starting oracle error number?

1096

---

How can we optimize a sql query?

1107

---

What is sql prepared statement?

1032

---

How to create an array in pl/sql?

1120

---

Describe types of sql statements?

1102

---

Write a sql query to get the third highest salary of an employee from employee_table?

1116

---