Answer / Rahul Bhardwaj

A subquery is a type of SQL query that is nested within another SQL statement. It retrieves data from a database based on the results of another SQL query. Subqueries can be used for various purposes, such as filtering data, performing calculations, and joining tables. The outer query retrieves data based on the results returned by the inner query. There are several types of subqueries in SQL: simple subquery, correlated subquery, existential subquery, and common table expression (CTE).

How is data stored on a disk?

1 Answers  

---

Compare SQL and PL/SQL.

3 Answers  

---

What is right join sql?

1 Answers  

---

what is HASH join?

2 Answers   Genpact, HCL,

---

How do I turn a list into a table?

1 Answers  

---

suppose u hav 1 book with set...page 1-100 n 101 -200 now print page from 2-100 n 102 -200... how we will do..?

6 Answers  

---

Source is Sales Table: Sno Prod Sales Sales_Amount 1 A 10 2000 2 A 20 1000 3 C 10 3000 4 D 30 4000 5 A 20 1000 Target : Sales_Count T_Sales_Amt Sales_Count(A) T_Sales_Amt(A) 90 11000 50 4000 In single query, pls tell me.

5 Answers   CGI,

---

find the third highest salary?

23 Answers  

---

What is the difference between pl and sql?

1 Answers  

---

what is 'trigger' in sql? : Sql dba

1 Answers  

---

Is it possible to update views?

1 Answers  

---

What is the difference between mdf and ndf files?

1 Answers  

---