Answer Posted / kavitha nedigunta

select * from emp e,(select max(sal) sal
from emp)a
where e.sal= a.sal;


select * from emp
where sal in(select max(sal) from
emp);

What is a table in a database?

573

---

What is difference between rank () row_number () and dense_rank () in sql?

573

---

Advantages and disadvantages of stored procedure?

576

---

What is a behavioral trigger?

513

---

What is pl sql architecture?

496

---

---

Can we use update in sql function?

573

---

What is a delimiter in sas?

540

---

What are the sql commands?

602

---

How do I view tables in sql developer?

510

---

What is the difference between clustered and non-clustered index in sql?

517

---

How do you optimize a stored procedure in sql?

497

---

What is the use of primary key?

535

---

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

562

---

What are types of indexes in sql?

537

---

What is group function in sql?

525

---