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 parameter modes supported by pl/sql?

525

---

Can a trigger call a stored procedure?

529

---

give the syntax of grant and revoke commands? : Sql dba

607

---

Is sql a microsoft product?

489

---

What is the difference between left outer join and left join?

503

---

---

What is varchar sql?

604

---

What is union?

645

---

What are the parts of a basic sql query?

503

---

What are transaction and its controls?

552

---

Is subquery faster than join?

562

---

What is difference between hql and native sql?

569

---

Write a sql query to find the names of employees that begin with ‘a’?

568

---

What is a dirty read sql?

468

---

how to calculate the difference between two dates? : Sql dba

541

---

what is “go” in t-sql? : Transact sql

592

---