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

Does group by remove duplicates?

1112

---

how many tables will create when we create table, what are they? : Sql dba

1144

---

What is the current version of sql?

1094

---

what is schema? : Sql dba

1147

---

what is sql server agent? : Sql dba

1182

---

what is dbms? : Sql dba

1061

---

If a cursor is open, how can we find in a pl/sql block?

1238

---

how to start mysql server? : Sql dba

1267

---

Is inner join faster than left join?

1276

---

what are the advantages of sql ? : Sql dba

1142

---

Is primary key always clustered index?

1095

---

how to escape special characters in sql statements? : Sql dba

1114

---

What is the current version of postgresql?

1178

---

what are all the common sql function? : Sql dba

1131

---

Can we use distinct and group by together?

1133

---