Answer Posted / amol londhe

Use the below Query:

Select Max(salary) from Emp
Where Max(salary) < (Select Max(salary) from emp
where emp-no=101);

what is a cursor? : Sql dba

557

---

What is rank dense_rank and partition in sql?

539

---

what is the bond code in materialized view?

2489

---

What are keys in sql?

551

---

What is a table in a database?

581

---

---

Explain the select statement in sql?

616

---

Explain unique key in sql.

564

---

What is difference between hql and native sql?

585

---

What is a join?

628

---

Can function return multiple values in sql?

533

---

What is fmtonly in sql?

534

---

What is the use of %rowtype?

537

---

What is online transaction processing (oltp)?

605

---

How do I order by ascending in sql?

542

---

Is left join and outer join same?

552

---