Answer / Indrajeet Kumar

You can optimize SQL queries by using indexes, reducing the amount of data returned, and avoiding SELECT *. Additionally, consider normalizing your database to reduce redundancy.

column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

5 Answers  

---

What is the maximum number of columns in sql table?

1 Answers  

---

How many unique keys can a table have?

1 Answers  

---

Write a unique difference between a function and a stored procedure.

1 Answers  

---

What is the purpose of cursors in pl/sql?

1 Answers  

---

What is pl sql block structure?

1 Answers  

---

Can a table have two primary keys?

44 Answers   HCL, MetaCube,

---

Is pl sql better than sql?

1 Answers  

---

what is HASH join?

2 Answers   Genpact, HCL,

---

What is the difference between left and left outer join?

1 Answers  

---

Differences between UNIQUE and DISTINCT in select statements

26 Answers   ABS, DELL, Deloitte, Hewitt, Oracle, Verinon Technology Solutions, Wipro,

---

Does truncate release storage space?

1 Answers  

---