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

How many sql commands are there?

1114

---

how to run 'mysql' commands from a batch file? : Sql dba

1110

---

what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba

971

---

What are the different tcl commands in sql?

1170

---

What are the advantages of sql?

1053

---

How do I save the results of sql query in a file?

971

---

What company owns postgresql?

1021

---

How to look at the current sql*plus system settings?

1143

---

What are different types of sql commands?

1109

---

Are subqueries faster than joins?

1014

---

What are the types of dbms?

968

---

Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.

1003

---

What is sqlite format?

1188

---

How would you pass hints to the sql processor?

978

---

What are the different types of triggers?

1128

---