Answer Posted / shailesh

select sal from emp where sal=(select max(sal) from emp
where sal<(select max(sal) from emp);

Name the operator which is used in the query for pattern matching?

685

---

How does cross join work in sql?

706

---

What is compilation error in pl sql?

700

---

What are the ddl commands?

718

---

What is pl sql script?

731

---

---

What are different clauses used in sql?

813

---

How do I clear the screen in sql plus?

756

---

what is view? : Sql dba

728

---

Are stored procedures compiled?

678

---

What is the size of partition table?

742

---

Can we commit in trigger?

702

---

Can I learn sql in a week?

753

---

list out some tools through which we can draw e-r diagrams for mysql. : Sql dba

702

---

What type of join is sql join?

719

---

Which data dictionary views have the information on the triggers that are available in the database?

941

---