Answer / Pankaj Kumar Dagar

Subqueries are used in SQL to nest one query inside another. They allow us to perform complex queries by combining multiple queries into a single query. For example, using a subquery we can retrieve data that matches a condition from one table and then use that result in a query on another table.

How to rename a column in the output of sql query?

1 Answers  

---

Why is sharding used?

1 Answers  

---

How can you fetch first 5 characters of the string?

1 Answers  

---

How do I write a cron which will run a sql query and mail the results to agroup?

1 Answers  

---

Why indexing is needed?

1 Answers  

---

one of the column in my table contains the data like SAL ---- 1000 1000 2000 3000 3000 So my requirement is i want output like SAL --- 1000 2000 3000 it mean i want to delete duplicate rows in the table permanently and i want output in the above formatow should u write query?

13 Answers   Cap Gemini, TCS,

---

Explain exception handling in pl/sql?

1 Answers  

---

Can we join more than 2 tables in sql?

1 Answers  

---

What is clustered and non-clustered indexes?

4 Answers   Microsoft,

---

what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?

1 Answers  

---

How do I install sql?

1 Answers  

---

Is it possible to pass parameters to triggers?

1 Answers  

---