Answer Posted / ajit

select *
from emp
where sal = ( select max(sal)
from emp
where level = &n
connect by prior sal > sal
group by level);

what is the different between now() and current_date()? : Sql dba

703

---

what is the difference between where clause and having clause? : Sql dba

724

---

What is the source code of a program?

707

---

How do I partition in sql?

704

---

What does count (*) mean in sql?

1291

---

---

What is Difference Between Unique and Primary Key Constraints?

827

---

How to get help at the sql prompt?

831

---

How can you save or place your msg in a table?

709

---

What is sql performance tuning?

650

---

What are the types of join and explain each?

773

---

Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?

903

---

What is record data type?

677

---

What is bulk compiling in pl/sql.?

798

---

what are the advantages of mysql in comparison to oracle? : Sql dba

704

---

What is composite data type in pl sql?

766

---