Answer Posted / abhijeet banarse

Select level,Max(sal) from emp1
Where level=&level connect by prior sal>sal
group by level;
Enter the level No=2 (Here enter 2 manually)

Explain ddl statements in pl/sql?

580

---

How do I find duplicates in a single column in sql?

540

---

How do I remove all records from a table?

570

---

which tcp/ip port does sql server run on? : Sql dba

519

---

Does truncate remove indexes?

563

---

---

When to use inner join and left join?

530

---

How can I make sql query run faster?

564

---

What is oracle and pl sql?

664

---

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

571

---

State some properties of relational databases?

586

---

what is innodb? : Sql dba

581

---

Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?

584

---

Can I copy :old and :new pseudo-records in/to an oracle stored procedure?

666

---

What is union, minus and interact commands?

750

---

describe mysql connection using mysql binary. : Sql dba

554

---