Answer / Harveer Singh

Both subqueries and JOINs have their uses, but it depends on the specific situation. Subqueries can be useful for complex queries that require nested conditions or multiple operations, while JOINs are generally more efficient for large datasets.

Can a table contain multiple foreign key’s?

1 Answers  

---

Is sql harder than python?

1 Answers  

---

what is the difference between stored procedure and packaged procedure

1 Answers   Google, Infosys,

---

Is it possible to use LONG columns in WHERE clause or ORDER BY?

3 Answers  

---

Does postgresql run on the cloud?

1 Answers  

---

what is autonomouse transaction?

3 Answers   Oracle,

---

Describe types of sql statements?

1 Answers  

---

Can you have multiple SPs with the same name on a database?

6 Answers   CGI,

---

What are predefined functions in sql?

1 Answers  

---

what is meant by nl2br()? : Sql dba

1 Answers  

---

What is compiled query?

1 Answers  

---

What is difference sql and mysql?

1 Answers  

---