Answer Posted / murali

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

What is normalization in a database?

615

---

What is difference between primary and secondary key?

520

---

What are sql procedures?

586

---

what is not null constraint? : Sql dba

555

---

What is pivot in sql?

514

---

---

How do I find duplicates in two columns?

557

---

What is meant by truncate in sql?

531

---

What is clustered index sql?

508

---

how to enter numeric values as hex numbers? : Sql dba

572

---

What is varchar example?

578

---

Can we insert data into view?

527

---

Is sql port 1433 encrypted?

578

---

What are the different types of constraints?

568

---

what is 'trigger' in sql? : Sql dba

561

---

What is latest version of sql?

530

---