Answer Posted / manish

select * from emp; --->> query

select * from emp where sal=(select max(sal) from emp);
--> here a sub query is also there

select * from emp outer where sal= ( select avg(sal) from
emp e where dept.e=dept.outer) --> corelated query

What are the different ddl commands in sql?

1066

---

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

1052

---

Which version of sql do I have?

1000

---

What are triggers and its types?

996

---

How do I make sql search faster?

937

---

How do I start sql from command line?

964

---

What are sql functions? Describe the different types of sql functions?

1059

---

What is a dynamic query?

973

---

Explain the savepoint statement.

1040

---

Write the alter statement to enable all the triggers on the t.students table.

1069

---

How to call a javascript function from pl sql?

1071

---

Which is faster subquery or join?

1148

---

What is the difference between the implicit and explicit cursors?

994

---

What is an index in sql with example?

920

---

Why do we use triggers?

916

---