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 is auto increment in sql?

589

---

when MSQL8.0 is in market

1604

---

Difference between truncate, delete and drop commands?

559

---

Mention what plvcmt and plvrb does in pl/sql?

643

---

What are the disadvantages of file system?

619

---

---

What is trigger in sql?

582

---

Why are indexes and views important to an organization?

529

---

What is sql procedures and functions?

531

---

What is the current version of sql?

540

---

how do you know if your mysql server is alive? : Sql dba

602

---

what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba

674

---

Write an sql query to select all records from the table?

558

---

What is the difference between database trigger and stored procedure?

558

---

What is java sql connection?

516

---

Is pl sql and postgresql same?

574

---